SQL Server Agent Job - Schedule daily except 1 day per month
- by Shevek
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?