Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Job Threshold - Different threshold for each job steps Expand / Collapse
Author
Message
Posted Wednesday, August 18, 2010 6:53 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Saturday, April 21, 2012 1:19 AM
Points: 34, Visits: 124
Hello,
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.
Post #971553
Posted Wednesday, August 18, 2010 11:01 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, August 1, 2014 6:18 AM
Points: 1,618, Visits: 20,980
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
Post #971613
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse