How to Store Scheduler Job Execution History into Apache Derby?

Hi ​@DhavalM 

The easiest way to achieve this is to switch Scheduler component to database persistence (Scheduler Server Component :: Ataccama ONE)
In this case all execution states will be stored to the database tables as described in Workflow and Scheduler Database Persistence Tables :: Ataccama ONE

Hi ​@AKislyakov ,

Thank you for providing the solution to my question. I appreciate it. However, I'm still unsure how to execute it. I’ve tried several approaches, but I couldn't find a clear step that explains how to store the execution states in my database tables. If possible, could you please share more detailed instructions or a small demo workflow/plan file that demonstrates how to set this up?

Thanks in advance!

Best regards,
Dhaval

Thanks a lot, ​@AKislyakov , for taking the time to share the ZIP file. I really appreciate your effort.

I’ve configured the server and runtime, but I’m still unclear on how to use SCHDEF_JOB_EXEC_STATE. Specifically, where am I supposed to use this command to store details about the schedule executions?

The runtime server will create table SCHDEF_JOB_EXEC_STATE and will use it to store execution details.

I’m unable to see the table in my DB Explorer. I’m using the default Apache Derby in the IDE, and here is the runtime config’s screenshot
 

 below is the configuration for the serverconfig as you suggested 
 

can you please guide me if this is the correct configuration?

Configuration seems correct, do you have any schedules defined and executed? What is shown on the Job Details page (the one in the topic header)

is this what you are referring to?

If your configuration is as shown, the data for this page should be fetched from the database. Maybe re-check connection details and try to refresh list of tables.

I just reconnected the database, and it is working now. Thank you so much ​@AKislyakov