Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Scheduling Jobs

Author  Topic 

moose051
Starting Member

15 Posts

Posted - 2001-04-17 : 21:59:02
I'm currently trying to figure out the best way that I can schedule one of my jobs that needs to run on the 3rd Wednesday of every month and then everyday following only for a week.
The only solution that I can think of is to schedule 2 jobs. One that runs every 3rd Wednesday and then the other job runs everyday but is disabled. I would then manually enable on the 3rd Wednesday and disable again in a week.
Surely there is a better option????
Using SQL 7.


   

- Advertisement -