How to get this db query out?

15 views
Skip to first unread message

javed...@gmail.com

unread,
May 14, 2023, 11:06:25 AM5/14/23
to rundeck-discuss
Hello,

In rundeck I want to run a database query given a job ID for a parent job and option value used.

Give me all the exeuction IDs, start and end time, status of exeuction and option value that was selected. 

The job depends on the option value passed to it, so its important that I can get results grouped this way. 

The job ID has has steps to execute other jobs, so it would be great if I can get something like this, where option.X is shared/common between parent and child

Job ID (Parent) -  Exeuction ID - Start Time - End Time - status - option.X.valueA
Child Job A - Exeuction ID - start Time - end time - status - option.X.valueA
Child job X - Exeuction ID - start Time - end time - status - option.X.valueA
...
Job ID (Parent) - Exeuction ID - Start Time - End Time - status - option.X.valueB
Child Job A - Exeuction ID - start Time - end time - status - option.X.valueB
Child job X - Exeuction ID - start Time - end time - status - option.X.valueB

rac...@rundeck.com

unread,
May 15, 2023, 9:55:42 AM5/15/23
to rundeck-discuss
Hi,

The key is to use a option on the child jobs to "receive" the data value gathered on the parent job. So, basically, the goal is to generate the data-value pn the parent and pass it as a anrgument on te job reference steps calls.

Here you can see a good example.

Regards.
Reply all
Reply to author
Forward
0 new messages