15.1
Check
Scheduled workflows using pmcmd command
pmcmd
getservicedetails -sv etltst222_iserv -d domain_ etltst222-u Administrator -p
Administrator –scheduled
getservicedetails -sv etltst222_iserv -d domain_ etltst222-u Administrator -p
Administrator –scheduled
15.2
List
all Scheduled Workflow details
SELECT
SUBJECT_AREA,
SUBJECT_AREA,
WORKFLOW_NAME,
SCHEDULER_NAME,
START_TIME,
END_TIME,
CASE
WHEN RUN_OPTIONS = 1 THEN ‘RUN ON DEMAND’
WHEN RUN_OPTIONS = 2 THEN ‘RUN ONCE’
WHEN RUN_OPTIONS = 4 THEN ‘RUN EVERY
DELTA_VALUE SECONDS’
DELTA_VALUE SECONDS’
WHEN RUN_OPTIONS = 8 THEN ‘CUSTOMIZED
REPEAT’
REPEAT’
WHEN RUN_OPTIONS = 16 THEN ‘RUN ON IS INT’
WHEN RUN_OPTIONS = 18 THEN ‘RUN ON IS INT
AND RUN ONCE’
AND RUN ONCE’
WHEN RUN_OPTIONS = 20 THEN ‘RUN ON IS INT
AND EVERY DELTA_VALUE SECONDS’
AND EVERY DELTA_VALUE SECONDS’
WHEN RUN_OPTIONS = 24 THEN ‘RUN ON IS INT
AND CUSTOMIZED REPEAT’
AND CUSTOMIZED REPEAT’
WHEN RUN_OPTIONS = 32 THEN ‘RUN
CONTINUOUSLY’
CONTINUOUSLY’
ELSE ‘DUMMY’ END AS RUN_OPTIONS,
SERVER_NAME
FROM
REP_WORKFLOWS
REP_WORKFLOWS
WHERE
–SUBJECT_AREA = ‘EDIWS’
–SUBJECT_AREA = ‘EDIWS’
RUN_OPTIONS <> 1
ORDER
BY 1,2,3
BY 1,2,3
15.3
Query
to check if any scheduled wf is deleted (scheduler deleted).
SELECT
*
*
FROM
OPB_TASK
OPB_TASK
WHERE
TASK_ID IN
TASK_ID IN
(SELECT WORKFLOW_ID FROM OPB_WORKFLOW WHERE
SCHEDULER_ID NOT IN
SCHEDULER_ID NOT IN
(SELECT DISTINCT SCHEDULER_ID FROM
OPB_SCHEDULER) );
OPB_SCHEDULER) );