April 26, 2010 at 10:28 am
I had a nice script for sql 2000 which would show all sql agent jobs, steps and schedules. Of course under 2005 won't work. I know the 3 tables below
select * from dbo.sysjobs
select * from sysjobsteps
select * from sysjobschedules
It is an easy link, where I am lost is when linking the jobs to the schedules is how to drive and when and how often?
April 26, 2010 at 10:41 am
Joc activity monitor will giev you all jobs with last run date and future run date , will you need more.
Regards
Durai Nagarajan
April 26, 2010 at 12:42 pm
Yes, I am looking for a schdule in a readable format which shows when each job is scheduled. I use to manipulate sysjobscheduled which is gone now
April 26, 2010 at 12:50 pm
This is right in MSDB: dbo.sysjobschedules
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
April 26, 2010 at 12:53 pm
Yes it is there but they took out all the columns to manipulate, only 4 colums
April 26, 2010 at 1:02 pm
I guess I'm confused, the job_id is right there along with the next run datetime. What else are you looking for?
If you need a literal breakdown of the schedule, try looking at sysschedules.
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
April 26, 2010 at 1:04 pm
Thanks that was the missing table I needed
April 26, 2010 at 1:07 pm
Cool. Glad I could help.
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
December 30, 2013 at 2:17 am
December 30, 2013 at 6:10 am
Marek Grzymala (12/30/2013)
If you need a literal breakdown of the schedule, try looking at sysschedules.
Except that in SQL 2000 there is no sysschedules table. What worked for me was this: http://solihinho.wordpress.com/2009/01/01/query-for-listing-sql-server-job-schedule/[/url]
Except this was specifically a question for 2005. Look at the original question. The OP had a script for 2000.
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply