Current Job exection status

To check current job execution status in SQL server the script is
EXEC MSDB..SP_HELP_JOB @EXECUTION_STATUS=1
 This  code will populate results of list of Jobs running in entire serverinstance, meaning across all databases.

No comments:

Post a Comment