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
 SQL Server Administration (2005)
 How NOT to run jobs on weekends

Author  Topic 

katarina07
Starting Member

31 Posts

Posted - 2008-07-23 : 02:31:58
Hi,

I have this question (SQL Server 2005):

what is the most ellegant way to run all the jobs from Monday to Friday but not on weekends?

The jobs are assigned to various schedules,
and I havent found the possibility to take out Sunday and Saturday directly in the "Schedule Properties" Window.

Thanks
Katarina

elancaster
A very urgent SQL Yakette

1208 Posts

Posted - 2008-07-23 : 02:54:44
it is there. if you choose 'weekly' you can then select tick boxes for which days of the week

Em
Go to Top of Page

katarina07
Starting Member

31 Posts

Posted - 2008-07-23 : 03:01:59
You are right, thanks.

Beginner's question :-)
Go to Top of Page

elancaster
A very urgent SQL Yakette

1208 Posts

Posted - 2008-07-23 : 03:03:59
no prob. i never thought it was an abvious place to put it myself. in your head you want it 'daily' (except for weekend of course)

Em
Go to Top of Page
   

- Advertisement -