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 |
clarkbaker1964
Constraint Violating Yak Guru
428 Posts |
Posted - 2007-04-06 : 12:23:03
|
Every so often people (network admins / developers / managers) as me when stuff is scheduled to run on the server. Generally they would like to know when they should schedule long running nightly processes in a timeframe that will not conflict with other nightly jobs.Does someone have a friendly format for this type of information?Some of the challenges I see are in interpreting the results of the system tables. i.e. Start/End Times recurring jobs etc.I looked through the forms a bit but their is a lot of content about problems with jobs. Help appreciated, select j.originating_server, j.name, j.enabled as job_enabled, s.name as schedule_name, s.enabled as schedule_enabled, s.* from sysjobs j join sysjobschedules s on j.job_id = s.job_idYou can do anything at www.zombo.com |
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-04-06 : 12:53:26
|
If you are interested in a third party tool, check out Idera's SQLschedule.We didn't purchase the tool as we don't have too many jobs to worry about, but the demo that they showed us seemed pretty good.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
readysetstop
Posting Yak Master
123 Posts |
Posted - 2007-04-06 : 13:59:29
|
Here's what I use:http://www.databasejournal.com/features/mssql/article.php/2197881 |
|
|
clarkbaker1964
Constraint Violating Yak Guru
428 Posts |
Posted - 2007-04-06 : 15:50:50
|
The database Journal Script is perfect for my needs thank you both for the rapid response.You can do anything at www.zombo.com |
|
|
|
|
|