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 Development (2000)
 Job Scheduling

Author  Topic 

pattikay
Starting Member

36 Posts

Posted - 2004-09-22 : 06:41:46
My clients want a job to run every 5th working day of the month.
Is this really possible using SQL job scheduler, if so how?

nr
SQLTeam MVY

12543 Posts

Posted - 2004-09-22 : 07:04:59
Set it to run every day and add a first step to check whether it's the fifth day of the month - if not do nothing.

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page

pattikay
Starting Member

36 Posts

Posted - 2004-09-22 : 08:16:48
Thanks , that sounds reasonable.
Go to Top of Page
   

- Advertisement -