Skip to main content

Dear experts,

is there a way to delete all background jobs by status (like error) with a scheduled database task?

Thank you.

Go to the system parameters, set 0 for parameter related to jobs with Error state and wait 10 minutes.


To elaborate on ​@knepiosko ‘s answer, what the waiting 10 minutes is going to do is to ensure that the Light Cleanup scheduled database task is going to run (as it’s typically set to run every 10 minutes interval).

 

The light clean up task (BATCH_SYS.FND_LIGHT_CLEANUP_) is one that takes care of deleting the background jobs in different states based on the system parameter settings (among other things that it does, such as checking and initiating IAL replication if there are any outstanding, cleaning Virtuals used in Projections, etc.)


Hi guys,

thank you a lot. It works.


Hi ​@Link,

Additionally, please refer to the below documentation on System Parameters. Under the "Background Jobs" category, you will find system parameters that define the cleanup age limit for Background Jobs in various states.

System Parameters - Technical Documentation For IFS Cloud

 

Thank you,

Aswin.


Hi ​@Link,

Additionally, please refer to the below documentation on System Parameters. Under the "Background Jobs" category, you will find system parameters that define the cleanup age limit for Background Jobs in various states.

System Parameters - Technical Documentation For IFS Cloud

 

Thank you,

Aswin.

 

Dear ​@Aswin Shadhujan 

thank you for the link. 👍🏽


Reply