Job Status Revised.

This procedure queries the sysjobs, sysjobschedules and sysjobhistory table to produce a resultset showing the jobs on a server plus their schedules(if applicable),how often the interval occurs(every X hours,min.,days,etc), the maximun duration, last duration,last status   of the job.This is a script that I modified and added to from M.Pearson.

2003-12-16

386 reads

Blogs

The Second Annual, Official WordPress.com Growth Summit is Coming and You Won’t Want to Miss It

By

Join us August 17 (Americas) or August 18 (Asia-Pacific). Register today!

The Post Pandemic Office Experience

By

I traveled to Pasadena, CA this week to work with a few other Redgaters...

Connecting to Azure Blobs in Power BI

By

The step-by-step process below walks through connecting to data housed in Azure Blob Storage...

Read the latest Blogs

Forums

Get the last day of the year based on a date range

By dqurve

I am trying to get the last day of the year from a date...

Put two queries together

By stephen.aa

Hello: Right now I have two queries as shown below: SELECT D.DocumentID AS [Document...

Excel Formula to create SQL Script for a Values Table

By allinadazework

Comments posted to this topic are about the item Excel Formula to create SQL...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers