Home Forums SQL Server 2012 SQL 2012 - General Getting Alert if job is running unusual RE: Getting Alert if job is running unusual
johnwalker10
SSCrazy Eights
Points: 9124
More actions
November 27, 2015 at 9:38 pm
#1842698
try the following system tables which hold the various bits of information on the job
•msdb.dbo.SysJobs
•msdb.dbo.SysJobSteps
•msdb.dbo.SysJobSchedules
•msdb.dbo.SysJobServers
•msdb.dbo.SysJobHistory