SQL EXPLORER
About Me
Mohamed Faizal
Barking, Essex, United Kingdom
MCITP DBA ,MCITP BI & Oracle OCP 11G
View my complete profile
Friday, April 24, 2015
To find the current SQL Agent job Execution Status
exec
msdb
.
dbo
.
sp_help_job
@execution_status
=
1
Or
We can able to monitor through Job Activity Monitor .
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment