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