SQL Job Threshold - Different threshold for each job steps

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Performance Tuning » SQL Job Threshold - Different threshold for...

SQL Job Threshold - Different threshold for each job steps

Rate Topic

Display Mode

Topic Options

Author

Message

Kicking_Fish0713

Posted Wednesday, August 18, 2010 6:53 PM

SSC 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

Adiga

Posted Wednesday, August 18, 2010 11:01 PM

SSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 12:23 PM
Points: 1,618, Visits: 20,901

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 »

Permissions