April 25, 2005 at 11:58 am
Which tables and what db hold the job details, schedules and results of all the jobs as listed in sql server agent / jobs??
thanks
April 25, 2005 at 12:14 pm
msdb
sysjob*
April 27, 2005 at 10:06 am
Here's a 'must have' for every DBA's desktop ... it's an electronic version of the systemtables in databases ...
http://www.microsoft.com/sql/techinfo/productdoc/2000/systables.asp
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
April 27, 2005 at 10:31 am
Thanks, Rudy. I had not seen this before. What a convenient resource!
April 29, 2005 at 7:56 am
Echo that! Thanks, thats great info.
May 2, 2005 at 2:40 am
Rudy,Thanks for the link
Rafi-
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply