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 Administration (2000)
 Reporting on Jobs and Schedules

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_id


You 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 Kizer
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

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
Go to Top of Page

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
Go to Top of Page
   

- Advertisement -