CODEWITHSUNDEEP
sql-serversql-server-2008sql-server-agent
Icemanind
Icemanind

Reputation: 48686

Determining if a job is running

I have a job set up in SQL Server called "Retreat Update". It is a job that the SQL Server Agent runs every 45 minutes. Is there a SELECT statement or a system stored procedure that I can execute to determine if the job is currently running or if its idle?

Upvotes: 0

Views: 198

Answers (1)

Christian Phillips
Christian Phillips

Reputation: 18749

I think you can use sp_help_job to see the status of the jobs on the server. You can see more information on it here.

From my search on SQL Help, try...

EXEC dbo.sp_help_job @Job_name = 'Retreat Update'

enter image description here

Upvotes: 2

Related Questions