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.
SELECT *FROM msdb.dbo.sysalerts
Stored information about current SQL Server Agent job activity and status.
SELECT *FROM msdb.dbo.sysjobactivity
Stored information about the execution of scheduled jobs by SQL Server Agent.
SELECT *FROM msdb.dbo.sysjobhistory
Stored information for each scheduled job to be executed by SQL Server Agent.
SELECT *FROM msdb.dbo.sysjobs
Stored schedule information for jobs to be executed by SQL Server Agent.
SELECT *FROM msdb.dbo.sysjobschedules
Stored information about each step of the jobs.
SELECT *FROM msdb.dbo.sysjobsteps
Stored information about job step logs.
SELECT *FROM msdb.dbo.sysjobstepslogs
Stored information about SQL Server Agent operator.
SELECT *FROM msdb.dbo.sysoperators
Stored information about SQL Server Agent job schedules.
SELECT *FROM msdb.dbo.sysschedules
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.