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
 Import/Export (DTS) and Replication (2000)
 Jobs steps

Author  Topic 

rookie_sql
Constraint Violating Yak Guru

443 Posts

Posted - 2007-10-09 : 09:45:30
Hi can you schedule a step of a job to run on a certain week day, what i like to do is to run step 1 of the job every day and then run the 2nd step only on tuesday is this possible ?

Kristen
Test

22859 Posts

Posted - 2007-10-09 : 09:51:53
Don't think so, I reckon you need two jobs for that.

Or Step 2 checks to see what day it is, and just Returns if Day <> Tuesday.

Kristen
Go to Top of Page
   

- Advertisement -