February 19, 2017 at 10:28 pm
Hi DBA gurus
I'm currently learning extended events to capture transaction history and modification of agent jobs such as who altered it, when the job was enabled, disabled who enabled and disabled it. I'm creating the extended events via extended event wizard but I am not sure what event names, global fields and session event filters if theres any to capture the information I need. Can someone help me? Thanks
February 20, 2017 at 7:07 am
First up, don't use the Wizard. The only advantage the Wizard has over the regular GUI is the Next button. You don't need that. Further, the Wizard doesn't offer all the functionality available through the regular GUI. You'll see that the GUI is effectively a wizard. Also, the GUI doesn't present Actions, which are added on top of events, as attractively as the wizard. Actions should only carefully used.
As to what you're trying to monitor, there aren't specific events for SQL Agent. I haven't tried setting up that kind of monitoring. I assume what you'd need to look for are particular calls in the msdb database.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply