SQLServerCentral.com Content tagged Monitoring, Jobs

Monitoring SQL Server Agent job run times

Wed, 01 May 2013 06:00:00 UT

Introduction A few months back, I was asked how long a particular nightly process took to run. It was a super...

New Custom Metric: Long Running Job

Fri, 05 Apr 2013 06:00:00 UT

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.

Job Summary

Wed, 10 Oct 2012 06:00:00 UT

This script lists the name, running and success status, last executed/currently executing step name, Average and Last duration, next run time and other related information about Jobs.

Job Summary

Wed, 10 Oct 2012 06:00:00 UT

This script lists the name, running and success status, last executed/currently executing step name, Average and Last duration, next run time and other related information about Jobs.

SQL Overview V - Monitoring Long Running Jobs

Fri, 29 Jul 2011 06:00:00 UT

Continuing with his series on monitoring your SQL Servers, David Bird now looks a a way to fin those long running, active jobs.

Monitor SQL Server Replication Jobs

Mon, 11 Jul 2011 06:00:00 UT

The Replication infrastructure in SQL Server is implemented using SQL Server Agent to execute the various components involved in the form of a job (e.g. LogReader agent job, Distribution agent job, Merge agent job) SQL Server jobs execute a binary executable file which is basically C++ code.

SQL Overview V - Monitoring Long Running Jobs

Fri, 29 Jul 2011 06:00:00 UT

Continuing with his series on monitoring your SQL Servers, David Bird now looks a a way to fin those long running, active jobs.

Checking the Job Status on Multiple Servers

Mon, 07 Sep 2009 06:00:00 UT

Keeping track of the jobs you have running across all your servers can be a challenge these days with fewer and fewer employees. New author Sivakumar Mahalingam brings us an article that shows one way to accomplish this task.