April 1, 2009 at 9:28 am
Hi there. This might be a bit of an ask but I was wondering if you could point me in the right direction re. creating a calendar listing when SQL Agent jobs are to be run. I can display the schedule descriptions e.g. "Every 1 week(s) on Monday, Tuesday, Wednesday, Thursday, Friday every 15 minute(s) between 7:45 and 18:30" but would like to try to use that to populate a calendar table (if possible).
Any ideas?
April 1, 2009 at 9:55 am
It's a bit of a mess and you'd have to decode the sysschedules table. I've seen some scripts try,but nothing that works great.
Might want to check out SQL Sentry's product. It does this very, very well.
April 2, 2009 at 3:20 am
I think I might have found what I was looking for:
http://weblogs.sqlteam.com/peterl/archive/2008/10/10/Keep-track-of-all-your-jobs-schedules.aspx
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply