Categories
Scripts

Script to find SQL Job activity details

Ive written a script to find the job activity details, this script will give the output similar to job activity monitor in SQL2K5 or SQL2K8. In my working place we had a request to collect the job details from all the servers which includes all version of SQL Server. Ive tried sp_help_jobactivity for SQL2K5 SQL2k8, however it doesnt provide the columns needed. So Ive written a script to get customized output, this script will also work with SQL2K. The script will fetch the following details

Categories
Scripts

Script to Get Job Details in SQL 2005

This script will get job details for all the jobs

Applies to

  • SQL Server 2000
  • SQL Server 2005
  • SQL Server 2008