Question

Is there a way to check logs to see who turned on or off database tasks or schedules?

  • 18 May 2023
  • 3 replies
  • 61 views

Userlevel 5
Badge +15

Hello,

 

We’d like to monitor who is turning scheduled database tasks on or off, but I’m not aware of any place this can be see from. We see in the background jobs of these tasks that the database task schedules are being turned off, and we’d like to see which user is doing so.

 

Thanks,
Bryan


3 replies

Userlevel 5
Badge +10

How about setting history log on the batch schedule tables? You may want to identify the correct table and enable logs. Below is a screen print of Apps 10, would be the same in other versions as well

 

Userlevel 5
Badge +15

Hi @malik.sally 

 

When I query this table it just shows me who created the database tasks, not who modified them or turned them off.

 

Thanks,
Bryan

Userlevel 5
Badge +10

Did you activate History Log in for this table? In there you can get the system to log Insert / Update / Delete.

If you do a select * from table… it wouldn’t show the changes….

you will have to switch on History Log to capture the changes.

Reply