sp_help_jobactivity system stored procedure provides information about the runtime state of SQL Server Agent jobs. This SP can be executed to check state of particular Job by passing value to either @job_id or @job_name parameter.
This SP has following parameters
| Parameter_name | Type |
| @job_id | uniqueidentifier |
| @job_name | sysname |
| @session_id | int |
This SP can be used along with sp_help_jobhistory to implement generic notification process for all Jobs.
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.