SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Reporting on Jobs and Schedules
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

clarkbaker1964
Constraint Violating Yak Guru

USA
428 Posts

Posted - 04/06/2007 :  12:23:03  Show Profile  Visit clarkbaker1964's Homepage  Reply with Quote
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

USA
37465 Posts

Posted - 04/06/2007 :  12:53:26  Show Profile  Visit tkizer's Homepage  Reply with Quote
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

USA
123 Posts

Posted - 04/06/2007 :  13:59:29  Show Profile  Visit readysetstop's Homepage  Send readysetstop a Yahoo! Message  Reply with Quote
Here's what I use:

http://www.databasejournal.com/features/mssql/article.php/2197881
Go to Top of Page

clarkbaker1964
Constraint Violating Yak Guru

USA
428 Posts

Posted - 04/06/2007 :  15:50:50  Show Profile  Visit clarkbaker1964's Homepage  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000