Add CHANGEAGENT to the SCHEDULE table or create a SCHEDULE Audit table

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.

  • Guest
  • Feb 24 2020
  • Reviewed: Voting Open
Organization Name (Please enter full organization name) Evangelical Lutheran Church In America
Reported Version 4.0