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

380 reads

Blogs

Information Measurement with SQL Server Part 4.5: The Squared L2 Family of Distances

By

By Steve Bolton …………In the last two installments of this series of amateur self-tutorials...

Security Learning Pathway at PASS Summit.

By

This year PASS is trying something new at PASS Summit. There are going to...

Pathways to Progress

By

One of the most significant and hardest challenges we face as data professionals (or...

Read the latest Blogs

Forums

Help with a stored procedure

By sridharkannan7

I have a table "Mytable" containing a list of IDs. There is a web...

Need to perform leaf level aggregation

By morbius82000

So I have a DW with  a table with some pre-aggregated scores (not my...

Migrating from (mostly) 2K8 to 2016

By JaybeeSQL

HI all, About to start this project and would be grateful for any good...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers