crazywolf2010
asked on
T-SQL for SQL Agent job details
Hi,
I am having difficulty looking at SQL agent job activity monitor at SSMS.
I am looking for set of TSQL well formatted scripts which will pull out details about jobs,status,execution times & other attributes from MSDB/DMV(storage for agent jobs)
Thanks
I am having difficulty looking at SQL agent job activity monitor at SSMS.
I am looking for set of TSQL well formatted scripts which will pull out details about jobs,status,execution times & other attributes from MSDB/DMV(storage for agent jobs)
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.