My organization is having issues where our Email schedules are getting disabled. The stored procedure that runs when someone disables the Email schedules has the CHANGEAGENT, but that value isn't being passed to the SCHEDULE table, because it doesn't have the CHANGEAGENT column, nor is there a SCHEDULEAUDIT table. This means we are unable to find who or what is disabling the Email schedules. We could like to recommend the CHANGEAGENT column be added to the SCHEDULE table and/or an Audit table be added for the SCHEDULE table.
Organization Name (Please enter full organization name) | Evangelical Lutheran Church In America |
Reported Version | 4.0 |
https://www.mssqltips.com/sqlservertip/3259/several-methods-to-collect-sql-server-stored-procedure-execution-history/
Otherwise, other methods may be desired : https://www.mssqltips.com/sqlservertip/3259/several-methods-to-collect-sql-server-stored-procedure-execution-history/