SQL Server Agent Job - Schedule daily except 1 day per month
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?
Put a job step as the first step in the job to look to see if the DATEPART(dd, getdate()) = 22 and if it does issue an sp_stopjob to stop the job.
One way to do this is to include a check for date in the script to be run and not run it on the 22nd.
Is this the only way though?