Skip to main content
Question

How to Store Scheduler Job Execution History into Apache Derby?

D
Universe Traveller
Forum|alt.badge.img

I'm working on workflows on my local machine and have set up a scheduler to trigger every 10 minutes. Each time the workflow runs, I would like to capture the following details from the job execution history, such as: Execution Date, Execution State, Executed Action ID, Details.
 

I am using Apache Derby as my database and would like to store this information there. Please let me know if there is a way to retrieve the above-mentioned details and store them in my database.

Thank you for your assistance.

Best regards,
Dhaval

Did this topic help you find an answer to your question?

A
Ataccamer
Forum|alt.badge.img+2

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

D
Universe Traveller
Forum|alt.badge.img
  • DhavalMUniverse Traveller
  • Universe Traveller
  • May 29, 2025

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

Reply


Community Terms of Use & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings