SQLTeam.com | Weblogs | Forums

SQL Agent job scheduling


#1

Hi,

I like to schedule the SSIS job to run on first and last month of each quarter only in weekdays. how can we achieve this in SQL agent job scheduling.

Thanks in advance.


#2

Since SQL Agent can't get to that level of detail you would need to schedule it to run everyday and have the code decide whether or not it is the appropriate time to run. The two options you have are

A) Add a step to the top of the SSIS package that checks a calendar table and either runs or skips the remaining code.
B) Write some wrapper code (i.e. stored procedure) that would check a calendar and decide whether or not to run the SSIS package

Mark