SQL Server Agent Job - Schedule daily except 1 day per month

Posted by Shevek on Server Fault See other posts from Server Fault or by Shevek
Published on 2010-03-12T11:56:24Z Indexed on 2010/03/12 15:17 UTC
Read the original article Hit count: 327

We need to run a daily job using SQL Server Agent (SQL 2000) but we don't want it to run on the 22nd of each month as there are other processes which only run on that day which will clash.

The recurring settings in Agent do not provide any exclusion options, is there any way to achieve this?

© Server Fault or respective owner

SQL Server Agent Job - Schedule daily except 1 day per month

Posted by Shevek on Super User See other posts from Super User or by Shevek
Published on 2010-03-12T11:56:24Z Indexed on 2010/03/12 11:57 UTC
Read the original article Hit count: 327

We need to run a daily job using SQL Server Agent (SQL 2000) but we don't want it to run on the 22nd of each month as there are other processes which only run on that day which will clash.

The recurring settings in Agent do not provide any exclusion options - is there any way to achieve this?

© Super User or respective owner

Related posts about sql-server-2000

Related posts about sql-server-agent