Redgate Software

Job overran Custom Metric

  • Article

This SQL Monitor custom metric tells you if a specific SQL Server Agent job that runs at the same time every day has overrun. The metric is useful when a job can have negative effects on other processes if it overruns.

2013-05-10

2,892 reads

New Custom Metric: Long Running Job

  • Article

SQL Monitor’s Job duration unusual alert is a powerful tool for keeping track of most jobs in your SQL Server environment. It works by comparing the running time of any job instance against the median for that job, and identifying when a variation in the job duration could hint at a performance problem. However, if your environment contains big jobs whose durations vary by several orders of magnitudes, it can be tricky to specify what kind of variation is expected and what would be unusual. For these cases, it is possible to go beyond the functionality of the built-in alert with a custom metric.

2013-04-05

2,857 reads

Blogs

Simple Graph Queries

By

In this post we saw how to create some graph tables with data. In...

Quick Blog: Making the Power BI PowerShell cmdlets easier to use

By

One of the top reasons I love PowerShell so much is that from the...

Trouble writing? Join the club. #JustWriteTech

By

I was talking with  a couple of excellent SQL people* recently, and we were bemoaning...

Read the latest Blogs

Forums

Is Data the Future of the Vibrant Web?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Is Data the Future of...

The log file of my user db is full. Please confirm if below resolves issue

By coolchaitu

Good morning experts, The log file of my user db is full. Could you...

I dont want the snapshot to be created for commands that have already been sent

By coolchaitu

Good Morning experts, I have a publisher db containing thousands of articles to be...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers