SQL Job Threshold - Different threshold for each job steps

Question

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply

Adiga One Orange Chip Points: 27284 More actions · Answer 1

You may use a custom query which monitors the job status. This query gives the status of a given job

EXEC msdb.dbo.sp_help_job @Job_name = 'The Job Name'

The following tables hold all the information about the jobs.

msdb.dbo.SysJobs

msdb.dbo.SysJobSteps

msdb.dbo.SysJobSchedules

msdb.dbo.SysJobServers

msdb.dbo.SysJobHistory

Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga