|
|
|
SSC Journeyman
 
Group: General Forum Members
Last Login: Thursday, February 11, 2010 10:20 AM
Points: 87,
Visits: 128
|
|
Hello, at my work I setup, and monitor my companies entire batch job schedule. We have around 100 jobs that vary from every minute, every hour, every day, every week, to every month. I have gone through, and continue to "show" the batch job schedule by manually entering every job and the order of the time run based on those categories I listed above into an Excel file. This has become somewhat painful if I ever want to tweak the schedule, or move jobs around.
What I would like to be able to do is script out the entire schedule. I found this script:
http://www.sqlservercentral.com/scripts/Maintenance+and+Management/62222/ that will do a select statement and return all of the jobs that are listed in the SQL Server Job Agent, and that's a great start.
My question, what does everyone else use to graphically show this schedule? Are there any tools out there that will do this, or any other scripts that will do this? I'm not sure if this is a question for Excel programming, or if people write their own VB or C# programs to generate this into another program.
An example of my Excel file is the following:
Monday thru Friday schedule
Job 1 9:45pm
Job 2 (started by Job 1)
Job 3 (started by Job 2)
Job 4 11:25pm
etc...
Any info is much appreciated.
|
|
|
|
