Show when all jobs were running

By Stephen Leach, 2007/07/26

Total article views: 273 | Views in the last 30 days: 9

Rate this |

Join the discussion |

Briefcase

This script returns a result set showing which jobs were running at what point during a given day.

One column is returned for each Job, and one row for each discrete portion of the day (configured by @TimeGranuality). A value of 1 indicates that the job was running at that point in time, 0 otherwise.

Particularly useful for scheduling jobs so that they do not clash with each other. Pasting the results into Excel and applying a bit of conditional formatting gives a nice graphical display.

By Stephen Leach, 2007/07/26

Total article views: 273 | Views in the last 30 days: 9

Your response

Rate this |

Join the discussion |

Briefcase

Related tags

Defrag Tables

By Rahul Sharma | Category: Maintenance and Management

| 3,580 reads

Drop all Connections from a Database

By Rahul Sharma | Category: Maintenance and Management

| 1,783 reads

Forcibly Shrink the Transaction Log

By Steve Jones | Category: Maintenance and Management

| 6,845 reads

Recompile Compiled Objects

By wali | Category: Maintenance and Management

| 996 reads

Like this? Try these...

What's Running

By Eric Wahner | Category: Lock and Connection Management

| 1,500 reads

Search for a text in all databases

By Rafal S. | Category: Miscellaneous

| 1,020 reads

Testing all procs before upgrading to Compatibility Level 90

By Luiz Barros | Category: Compatibility

| 642 reads

Already registered?

Free registration required

To read the rest of this article, and access thousands of other articles, we ask you to register on the site and subscribe to our newsletters.

Register

E-mail address:
Password:
Password (confirm):

Subscriptions

We ask you to register on the site and subscribe to our newsletters. Subscribing to our newsletters gets you:

ALL of our content (thousands of articles, scripts, and forum postings)
A daily newsletter (example)
A weekly news round up (example)
The opportunity to ask and answer questions in our forums
A daily Question of the Day to test and help you increase your knowledge of SQL Server.

We ask that you give the newsletter a try for a week. Over 200,000 SQL Server Professionals a day find it entertaining and useful. If not, you are welcome to unsubscribe at anytime.

Steve Jones
Editor, SQLServerCentral.com