Tag: job details
-
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,…
-
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