June 17, 2005 at 1:49 pm
I maintain databases on about 20 servers and I would like to generate a file that would contain all of the information about the scheduled jobs in sql server agent for a server (Script, times that jobs run, etc.). I am sure that it is stored somewhere in msdb but I cannot locate the correct table. I would even be happy to generate a hard copy to keep just incase I loose a server. In the past I have done this documentation with print screens and there has got to be an easier way. Any Ideas?
June 17, 2005 at 3:14 pm
The sp_help_job procedure is pretty extensive on the information it can return. If you look it up in Books Online, it details all the inputs and outputs. Let us know if that's what you are looking for.
Derrick Leggett
Mean Old DBA
When life gives you a lemon, fire the DBA.
June 24, 2005 at 6:57 am
Derrick,
Thank You very much!!!! This is exactly what I was looking for.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply