January 5, 2006 at 10:45 am
Could you tell me which system table would contain the property values for each job?
Chris
January 5, 2006 at 11:11 am
Look at all the tables starting with sysjob in msdb
---------------------------------------------
[font="Verdana"]Nothing is impossible.
It is just a matter of time and money.[/font]
January 5, 2006 at 11:22 am
Thank you, this information was extremely helpful.
January 6, 2006 at 12:26 pm
Here's a link no DBA shoud be without:
http://www.microsoft.com/sql/prodinfo/previousversions/systables.mspx
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply