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.
| Author |
Topic |
|
miked1978
Starting Member
25 Posts |
 Posted - 2009-07-30 : 08:41:06
|
| We have a ton of jobs that are scheduled to run throughout the week. Is there a way to view the schedule of each job without clicking on each run? I didn't know if there could be a script I could write to give me on the jobs that run on a specific day or not. Or a view I can look at. I have access to SQL 2000 and SQL 2005. |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2009-07-30 : 09:50:52
|
| select * from msdb..sysjobschedulesMadhivananFailing to plan is Planning to fail |
 |
|
|
|
|
|
Job schedules