InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 13:38:12 GMT20http://www.sqlservercentral.com/Forums/Topic971553-360-1.aspxYou may use a custom query which monitors the job status. This query gives the status of a given job[code="sql"]EXEC msdb.dbo.sp_help_job @Job_name = 'The Job Name'[/code]The following tables hold all the information about the jobs. msdb.dbo.SysJobs msdb.dbo.SysJobSteps msdb.dbo.SysJobSchedules msdb.dbo.SysJobServers msdb.dbo.SysJobHistoryWed, 18 Aug 2010 23:01:16 GMTAdigahttp://www.sqlservercentral.com/Forums/Topic971553-360-1.aspxHello,Can I set the rule that looks at long running SQL jobs to have different thresholds for each job steps? specific for each job steps? I would like to actually have different thresholds if its possible.Please advise.Wed, 18 Aug 2010 18:53:21 GMTKicking_Fish0713