All the SQL Server Agent Jobs details are logged into the MSDB Database tables .

These tables contains information for each SQL server Agent job like : JobID, sessionID, RunDate , Enabled Status, Owner, Job Steps, Last Run outcomes etc . Tables which are commonly used are :

select * from [dbo].[sysjobactivity]

select * from [dbo].[sysjobhistory]

select * from [dbo].[sysjobs]

select * from [dbo].[sysjobschedules]

select * from [dbo].[sysjobservers]

select * from [dbo].[sysjobsteps]

select * from [dbo].[sysjobstepslogs]

• Uncategorized