job scheduling

Question

 

Hi,

 

How to schedule SQL server job to execute SSIS package from 4th working day to 10th working day of each month.

 

Regards,

Geetha.K

Answer 1

There are a few threads here on the forums that deal with "working days" or something similar.  If you use the search function you will find that there is some debate as to what is the best way to deal with this situation.  You will probably need to create a date dimension that has a value for whether or not each day is a "working day", perhaps keeping a value showing which working day this is during the month.  As these values are not standard across companies within the same country, let alone across the globe this will more than likely need to be proprietary to your company.  From there you could query the table as a first step in your package and stop the process if it is not within the stated bounds.


Hope this helps.

Answer 2

Hello,

 

You should :

 

1. Create a job which runs yous SSIS package with no schedule (JOB 1)

2. Create a stored procedure (SP_MyStoredProc) which calculates your interval and verify if you are in the working day and day number and run JOB 1 if the condition is respected

3. Create JOB 2 with "once per day" schedule interval which has one step - run your SP_MyStoredProc

 

That's all  )