Please start any new threads on our new site at 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 

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,

j.enabled as job_enabled, 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

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

Posting Yak Master

123 Posts

Posted - 2007-04-06 : 13:59:29
Here's what I use:
Go to Top of Page

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

- Advertisement -