Event daily schedule execution

One of the way is to find database task schduled in daily rutine and then use BACKGROUD_JOB_PROCESSED built-in event to exeute event action with condition equal to database procedure.

I don’t understand how to gather informations that you mention and how to set up the database task scheduled to execute my custom event

Hello ​@knepiosko,

After a night to think about it, I understood what you were saying and how to implement your solution into my environment.

Is there a way to create a new task scheduled to execute my event instead of using an existing one ?

Hi ​@Corentin 

My propose is to schedule any cleanup database task which hasn’t been scheduled yet and is not going to be scheduled in future. Example procedure MOBILE%

Yes, it is possible to schedule the execution of an event in IFS, but not directly through the Event Action configuration alone. You need to use Background Jobs or Scheduled Tasks in IFS to achieve this.

How to Schedule an Event Daily

1. Create the Event Action

   • Define your event logic in Event Action Studio or Event Management.

2. Wrap the Event in a Custom LU or PL/SQL Procedure

   • If the event is based on a database trigger, you cannot schedule it directly.
   • Instead, create a procedure that calls the event logic.

3. Use Background Jobs

   • Navigate to:
     Solution Manager → Background Jobs → Schedule Job
   • Create a job that runs your procedure or report.
   • Set the recurrence to Daily.

4. Alternative: Scheduled Task

   • In Application Server Tasks, you can configure scheduled tasks for recurring execution.

Hi ​@Corentin 

You can use the same method describe in this idea to schedule an event action

Timer start event in workflow | IFS Community

• Create a simple custom entity with one attribute
• Create a MIGRATE_SOURCE_DATA data migration job to enter data to above entity (use DUAL as source and just use a default value in the source mappings for the column)
• Schedule the DM job as you wish
• Create an event to trigger when creating a new record on our custom table
• create an event action

Hi ​@knepiosko, I tried to implement your solution but I have some problems.

First, BACKGROUND_JOB_PROCESSED event doesn’t exist, there is only BACKGROUND_JOB_IS_PROCESSED or BACKGROUND_JOB_IN_PROGRESS.

I tried both and in both cases, it seems that my event action is not triggered because it is supposed to trigger a workflow but nothing happens. I activated the start watch option on my workflow before executing my database task and nothing is returned and no error message is shown either.

Hi ​@dsj 

Thanks for your answer ! I understand what your suggesting.

I tried implementing it but I never created migration job for now and my tests failed…

Could you precise me how I have to create my migration job (what variable where) so that I can try it correctly ?

Hi ​@Savinda.Tennakoon,

I don’t have Event Action Studio or Event Managemeent.

I don’t really understand how to proceed with your indications…

We want to do everything in IFS, no database trigger, just trigger event in IFS Cloud from IFS Cloud