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.


Please share your ideas and opinions about this topic with me, your contribution will add true value to this topic.
If anyone has doubts on this topic then please do let me know by leaving comments or send me an email.

If you like this post, then please share it with others.
Please follow dbrnd.com, I will share my experience towards the success of Database Research and Development Activity.

I put up a post every day, please keep reading and learning.
Discover Yourself, Happy Blogging !
Anvesh M. Patel.

More from dbrnd.com

Leave a Reply

Be the First to Comment!

Notify of
avatar
wpDiscuz