April 21, 2008 at 3:26 am
Hi,
I would like to know, is there any option or sys table contains the information of the user who has changed the Automated job.
We could see the last modified date, but I need to know who has made the changes to the job.
If anyone has information about it, kindly let me know.
Thanks
Kumar
April 21, 2008 at 6:21 am
[font="Courier New"]Kumar,
I hope you can't get information of the user who has modified the job in systables. You can create a trigger to monitor the same, hence when ever the event occurs it will capture the username and insert in a user table. Later you can analyse the table.
Only job owner or sysadmin can modify the jobs!!![/font]
Regards..Vidhya Sagar
SQL-Articles
April 21, 2008 at 7:42 am
Vidhya,
I too know that we could perform this task using the trigger, or if you we know some user might change the job, then we could run the profiler at that time.
But if there is no trigger written to capture the change, then we only have the last modified date and time of the job. I too check for if there would be some undocumented Trace flag to track these changes.. but no help... 🙁
Hope that would be the last option to go triggers.
Regards
Kumar
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply