Extracting Recurring Job Templates in Siebel: A SQL Query Guide

Recurring jobs in Siebel are crucial for automating various tasks, including running workflows at specified intervals. Understanding how these jobs are set up can be key to managing and troubleshooting automated processes. In this blog, we’ll explore an SQL query that retrieves a list of all recurring job templates configured in Siebel. It will provide essential details such as the name of the job, the component where the job runs, the trigger expression, and the workflow associated with it.

SELECT a.name,
  a.action_type,
  a.display_name,
  a.file_loc Component_type,
  c.display_name ComponentName,a.ENABLED_FLG,
  listagg(b.name||':' ||b.param_value,';') within group (order by b.name) as Job_parameter,a.DESC_TEXT
FROM S_SRM_ACTION a,
  S_SRM_ACT_PARAM b,
  S_SRM_ACTION c
WHERE b.action_id = a.row_id
AND c.row_id      = a.PAR_ACTION_ID
group by 
a.name,
  a.action_type,
  a.display_name,
  a.file_loc ,
  c.display_name,a.DESC_TEXT,a.ENABLED_FLG

If you’re tasked with monitoring or updating recurring jobs, this query provides all the relevant information in a single result set. You can quickly identify which workflows are running on specific components and what triggers them.

Customization:

You can modify the WHERE clause to filter specific jobs by name or component, based on your requirements.

Conclusion:

This SQL query makes it easy to retrieve and manage recurring job templates in Siebel, giving you a clear view of their configuration. With the job name, component, trigger expression, and workflow details available in one place, this query is highly useful for Siebel administrators and developers alike.