CODEWITHSUNDEEP
sql-server-2008-r2sql-agent-job
Qué Padre
Qué Padre

Reputation: 2083

Is there any way to know SQL server agent job status?

I am using SQL server 2008 R2 and I am wondering if there is a way to know SQL server agent job status (running/stopped) with some query. Do you have any suggestions?

Upvotes: 1

Views: 97

Answers (1)

Linda Lawton - DaImTo
Linda Lawton - DaImTo

Reputation: 116868

There is a system stored procedure sp_help_job. This returns information on the job, its steps, schedules and servers. For example

EXEC msdb.dbo.sp_help_job @Job_name = 'The name of the job'

Upvotes: 2

Related Questions