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 2005 Forums
 Transact-SQL (2005)
 Run DTS First Monday after First Saturday

Author  Topic 

ddobbertin
Yak Posting Veteran

51 Posts

Posted - 2008-02-15 : 10:55:50
I have a DTS package that I need to run the first Monday after the first Saturday of every month, no other date is possible. Any ideas of how to schedule that? Any and all help is appreciated!

ddobbertin
Yak Posting Veteran

51 Posts

Posted - 2008-02-15 : 11:55:54
I must've thrown out a stumper...
Go to Top of Page

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2008-02-15 : 12:08:10
schedule it to run on every monday and check in code if it's the first after the first sunday.
if it's not then exit the job.

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
SSMS Add-in that does a few things: www.ssmstoolspack.com <- new version out
Go to Top of Page
   

- Advertisement -