SQL Server: Important System Tables for Alerts, SQL Jobs, Operators

In this post, I am sharing a list of important system tables to find information about the SQL Server Agent.

This system tables are very useful for a Database Administrator to find out different information about the SQL Job, Alerts and Operators.

The MSDB contains all SQL Server Agent information in the following tables.

Stored information about the alerts.

Stored information about current SQL Server Agent job activity and status.

Stored information about the execution of scheduled jobs by SQL Server Agent.

Stored information for each scheduled job to be executed by SQL Server Agent.

Stored schedule information for jobs to be executed by SQL Server Agent.

Stored information about each step of the jobs.

Stored information about job step logs.

Stored information about SQL Server Agent operator.

Stored information about SQL Server Agent job schedules.

Anvesh Patel

Leave a Reply

Be the First to Comment!

Notify of
avatar
wpDiscuz