In SQL Job, we can know which schedule job is running from the below step:
Microsoft SQL Server Management Studio -> Server name-> SQL Server Agent-> Job Activity Monitor->Right click -> View Job Activity
You can view which job is running with check on "Status" column
Another way to do this is run this query in Microsoft SQL Server Management Studio->New query
msdb.dbo.sp_get_composite_job_info NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL
This script will show which job is running now.
No comments:
Post a Comment