T SQL Script – Get SQL Job Details and history details

Description

The Script “sp_GetJobDetails” has 3 resultsets to get job details and its history analysis result. The Procedure has a parameter that gets Job_Id, however is an optional, a NULL value can be passed to fetch job details and History information for all jobs configured in the server.

The script will be very useful and handy for those who are looking for SQL Server Agent Job details and its execution details.

DOWNLOAD SCRIPT

Note: This is an enhanced version of my earlier script posted in MSDN Gallery at https://gallery.technet.microsoft.com/T-SQL-Script-Get-Job-231229b4.

Please download the script and have your suggestions.

Advertisements

3 thoughts on “T SQL Script – Get SQL Job Details and history details

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s