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

384 reads

Blogs

Daily Coping 2 Mar 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Updated Pluralsight Course – Kubernetes Installation and Configuration Fundamentals

By

My updated course “Kubernetes Installation and Configuration Fundamentals” in now available on Pluralsight here! If you want...

Power BI and a Star Schema

By

I sometimes get asked from customers if they should use a star schema or...

Read the latest Blogs

Forums

[ADO NET Source [2]] Error: The ADO NET Source was unable to process the data. F

By yrstruly

I am trying to get data from myslq into mssql with ssis. I am...

xp_cmdshell

By ramyours2003

how to check which job or  stored procedure using xp_cmdshell in sql server ?

consolidate error logs

By ramyours2003

i need to configure job to consolidate sql error log sizes   from multiple servers...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Adding N/A

See possible answers