Skip to main content
Question

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


Forum|alt.badge.img+17

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

Forum|alt.badge.img+11
  • Hero (Partner)
  • 188 replies
  • May 19, 2023

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

 


Forum|alt.badge.img+17
  • Author
  • Superhero (Customer)
  • 254 replies
  • May 19, 2023

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


Forum|alt.badge.img+11
  • Hero (Partner)
  • 188 replies
  • May 23, 2023

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings