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
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
Hi
When I query this table it just shows me who created the database tasks, not who modified them or turned them off.
Thanks,
Bryan
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.