Skip to main content

Hi everyone,

is there database task that we can schedule to delete background jobs in state Error from a specific batch queue only?

 

Use case: 

We have scheduled tasks to transfer attached documents to our connected DMS. Due to wrong usage of document classes or attaching documents to wrong logical units these scheduled tasks generate a lot of BG job errors.

Of couse we know that this is not a solution to the wrong usage issues but the documents need to be changed by our colleagues from the corresponding departments which takes some time (due to their daily business). We just want to clean up those erroneous background jobs which do not need any of our attention.

 

We are on Apps 10.

 

Thanks in advance!

Hi ​@PATHDR 

check this scheduled database task.

 

I hope it will help you.

 


Hi ​@Link 

Thanks for your reply but this one only cleans up application messages.

I would like to clean up Background Jobs in Error state for a specific batch queue.


There isn't a queue for background jobs in APPS10.

In general, you can change this value in System Parameters.

 


Reply