Below are some examples of the tables in msdb database which contains information about the Jobs and its steps.
• Sysjobs: Stores the information for each scheduled job to be executed by SQL Server Agent
• Sysjobsteps: Contains the information for each step in a job to be executed by SQL Server Agent.
Submitted questions and answers are subject to review and editing, and may or may not be selected for posting, at the sole discretion of w3Sniff.
Get Started
Comments
Leave a Comment