You can use a combination of an event of type PL/SQL block and an existing scheduled task to do this. You write your piece of code to figure out the users who needs to be alerts in the code and then you “command_sys.mail” standard procedure to send the email out to those users. The trigger point for the event to fire would be the execution of the aforementioned scheduled task. You can use something like the Heavy cleanup job which usually runs once a a day and use the standard BACKGROUND_JOB_IS_PROCESSED event to capture the execution of the job to trigger your event action.
You can use a combination of an event of type PL/SQL block and an existing scheduled task to do this. You write your piece of code to figure out the users who needs to be alerts in the code and then you “command_sys.mail” standard procedure to send the email out to those users. The trigger point for the event to fire would be the execution of the aforementioned scheduled task. You can use something like the Heavy cleanup job which usually runs once a a day and use the standard BACKGROUND_JOB_IS_PROCESSED event to capture the execution of the job to trigger your event action.
@Sajith D , thank you very much for your help and suggestion!
I ended up doing what you said, only changing the background job that launches the event, as Heavy Cleanup runs 3 times a day in our case, so I ended up using a background job we created for a quick report, that runs daily.
Just a question, will this action be a problem when we get updates or deliveries, considering it runs on a standard event, and not a custom event?
Good to hear that you got it working the way you wanted it to.
it’s quite unlikely that you would face any issues with an update or a patch. The standard BACKGROUND_JOB_IS_PROCESSED event has been there forever through multiple major versions and i don’t see that going away any time time soon.
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.
