Skip to main content
Solved

How to delete several background jobs

  • February 5, 2025
  • 5 replies
  • 173 views

Link
Superhero (Customer)
Forum|alt.badge.img+23
  • Superhero (Customer)

Dear experts,

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

Thank you.

Best answer by knepiosko

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

5 replies

Forum|alt.badge.img+17
  • Superhero (Partner)
  • Answer
  • February 5, 2025

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


Forum|alt.badge.img+12
  • Hero (Customer)
  • February 5, 2025

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.)


Link
Superhero (Customer)
Forum|alt.badge.img+23
  • Author
  • Superhero (Customer)
  • February 6, 2025

Hi guys,

thank you a lot. It works.


Aswin Shadhujan
Hero (Employee)
Forum|alt.badge.img+9

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.


Link
Superhero (Customer)
Forum|alt.badge.img+23
  • Author
  • Superhero (Customer)
  • February 7, 2025

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. 👍🏽