--List of all the jobs currently running on server
SELECT server as ServerName,
database_name as DBName,
name as Job_Name,enabled,
description as JobDescription,
step_name,command
FROM msdb.dbo.sysjobs job JOIN
msdb.dbo.sysjobsteps steps
ON job.job_id = steps.job_id
WHERE job.enabled = 1
No comments:
Post a Comment