Friday, January 20, 2017

Informatica Metadata Queries - 15 SCHEDULER




15.1         Check Scheduled workflows using pmcmd command



pmcmd getservicedetails -sv etltst222_iserv -d domain_ etltst222-u Administrator -p Administrator –scheduled


15.2         List all Scheduled Workflow details 


SELECT 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'
    WHEN RUN_OPTIONS = 8 THEN 'CUSTOMIZED REPEAT'
    WHEN RUN_OPTIONS = 16 THEN 'RUN ON IS INT'
    WHEN RUN_OPTIONS = 18 THEN 'RUN ON IS INT AND RUN ONCE'
    WHEN RUN_OPTIONS = 20 THEN 'RUN ON IS INT AND EVERY DELTA_VALUE SECONDS'
    WHEN RUN_OPTIONS = 24 THEN 'RUN ON IS INT AND CUSTOMIZED REPEAT'
    WHEN RUN_OPTIONS = 32 THEN 'RUN CONTINUOUSLY'
    ELSE 'DUMMY' END AS RUN_OPTIONS,
  SERVER_NAME
FROM REP_WORKFLOWS
WHERE --SUBJECT_AREA = 'EDIWS'
  RUN_OPTIONS <> 1
ORDER BY 1,2,3



15.3         Query to check if any scheduled wf is deleted (scheduler deleted).


SELECT *
FROM OPB_TASK
WHERE TASK_ID IN
  (SELECT WORKFLOW_ID FROM OPB_WORKFLOW WHERE SCHEDULER_ID NOT IN

    (SELECT DISTINCT SCHEDULER_ID FROM OPB_SCHEDULER) );