I am trying to schedule a job not to run on holidays in SQL server 2005.

Hi,

I want to schedule a job that runs daily but not on holidays and I am using SQL server 2005. Looking for some advice...

thanks,

Include an additional step in the job and check within a stored procedure against a vacation table (which has to be built on your own). If the job is within vacation time, throw an error with raiserror and the appropiate message. Check the status of the job step to use the "Stop executing the job after an error".

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||

Do you mean even in Saturdays and Sundays?

You can schedule a job to run between Monday to Friday on weekly basis, and for any additional holiday requirement you need to follow what is suggested above.

|||Thanks for replying. I will try.|||as a variation on this theme, you could set up a seperate job that disables or enables jobs depending on whether a day is holiday or not. More risky, perhaps (if it doesn't run, then X jobs are not set correctly).