3 Replies Latest reply on Aug 16, 2021 8:00 AM by Nico Heinze

    Working day table to control the execution of PowerCenter Workflow

    Eugene Chen New Member

      We have a wf_DAILY workflow in PowerCenter Standard Edition 10.5 to be scheduled to execute on 01:00 every day after the daily batch. However, we want this workflow wf_DAILY to be called every day but checking the WORK_DAY table maintained in MSSQL with two columns DATE and STATUS (WORKDAY or NON-WORKDAY.) The very first task is to check system day in the WORK_DAY to decide to continue execute the rest of workflow or simply stop running. Therefore, we want to use custom table to decide whether to run the whole workflow or not.