Search sqlserver-dba.com
Follow sqlserver-dba.com
*Use the Comments section for questions
SQLServer-DBA.com Links
Recent Posts
- The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction.
- How to find privilege changes with SQL Server Default Trace
- sys.dm_server_services - How to check if SQL Server service is running or not?
- Msg 3023, Level 16, State 2 Backup, file manipulation operations (such as ALTER DATABASE ADD FILE) and encryption changes on a database must be serialized. Reissue the statement after the current backup or file manipulation operation is completed.
- Can we restore a database to an older version in SQL Server?
- How do I save all SQL Agent Jobs
- How to view SQL Server mount point space without access to server
- DBCC SHRINKFILE: page could not be moved because it is a work table page.
- SQL Agent Last Modified explanation
- Sql certificate chain was issued by an authority that is not trusted
How can I check SQL Agent Job current status ?
13 October,2022 by Tom Collins
Question: How can I check the current SQL Server Agent Job Status?
Answer: You have a few different options to check the SQL Server Agent Jobs Status.
Option 1 : SQL Server Job Activity Monitor .Check the "Status"
Option 2 : Use the syshobhistory run_status column - Check SQL Agent Job Exceution Status and Messages Generated with a sql script
Option 3 : SQL-DMO , reading the output from the CurrentRunStatus Property
The CurrentRunStatus property returns the executing state of a SQL Server Agent job.
If you're using the SQL-DMO method - the see the latest status you'll need to apply Refresh method.
Here is a short code snippet in Powershell.if you want to monitor this over a period of time you'll need to apply some extra logic - such as a while .. loop with a sleep step
$jobStatus = $job.CurrentRunStatus
$job.Refresh() #refresh the job connection
$jobStatus = $job.CurrentRunStatus #s status
| SQLDMOJobExecution_BetweenRetries | 3 | Job is waiting on a job step retry attempt. |
| SQLDMOJobExecution_Executing | 1 | Job is executing. |
| SQLDMOJobExecution_Idle | 4 | Job is idle, awaiting its next scheduled execution. |
| SQLDMOJobExecution_PerformingCompletionActions | 7 | All executable job steps complete. Job history logging in progress. |
| SQLDMOJobExecution_Suspended | 5 | Job is suspended. |
| SQLDMOJobExecution_Unknown | 0 | State cannot be determined. |
| SQLDMOJobExecution_WaitingForStepToFinish | 6 | Job is waiting on the outcome of a step. |
| SQLDMOJobExecution_WaitingForWorkerThread | 2 | Job is blocked, unable to obtain a thread resource. |
Read More on SQL Agent
List enabled status of SQL Server Agent Jobs
Author: Tom Collins (http://www.sqlserver-dba.com)
Share:
Verify your Comment
Previewing your Comment
This is only a preview. Your comment has not yet been posted.
As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.
Having trouble reading this image? View an alternate.
Posted by: |