Scheduling

1. Scheduling and Running Workflows

http://www.info-etl.com/course-materials/scheduling-and-running-workflows


2. HOW TO: Configure a PowerCenter workflow to run periodically between a specific start time and end time using the command line (pmcmd)

Solution

Consider the following requirement: A workflow, WF1, is to run every 5 minutes from 9:00 AM to 2:00 PM every day. This cannot be achieved using the PowerCenter scheduler directly because if you provide a start time you can stop the workflow manually or end on some particular date or end after some runs, but you cannot end at some particular time say at 2:00 PM if the workflow has started to run at 9:00 AM. A feature request (CR 84097) has been submitted to add this feature in a future release of PowerCenter. Workaround This can be achieved with using two workflows; a 'schedule' workflow ( WF_schedule ) and an 'unschedule' workflow ( WF_unschedule ). The WF_schedule and WF_unschedule workflows can be used to run the workflow WF1 between the expected start and end time as follows: Schedule Workflow (Daily Start Time) You can schedule the workflow, WF1, using the pmcmd scheduleworkflow command in the WF_schedule workflow. Create a workflow, WF_schedule. Add a Command Task with the following command: pmcmd scheduleworkflow -s IN158335:4001 -u Administrator -p Administrator -f test1 WF1 This command will schedule the workflow WF1. Schedule the WF_schedule workflow to run every day once at 08:58 AM. Unschedule Workflow (Daily End Time) You can unschedule the workflow WF1 using using the pmcmd unscheduleworkflow command in the WF_unschedule workflow. Create a workflow, WF_unschedule. Add a Command Task with the following command: pmcmd unscheduleworkflow IN158335:4001 -u Administrator -p Administrator -f test1 WF1 This command will unschedule the workflow WF1. Schedule the WF_unschedule workflow to run every day once at 2:02 PM.

https://kb.informatica.com/howto/1/Pages/21253.aspx



3. HOW TO: Configure a PowerCenter workflow to run periodically between a specific start time and end time using a condition link

Solution

There is no direct option available in the scheduler to schedule a workflow to run daily per hour or for some minutes between specific periods of time, say from 9 A.M to 3 P.M.  To resolve this issue you need to configure the scheduler settings as follows: Open the workflow. Enter the following condition for the link from start task to the session:  GET_DATE_PART(SYSDATE,'HH24') >=9  AND GET_DATE_PART(SYSDATE,'HH24') <=15 Go  to Workflows > Edit > Scheduler. In the Schedule option, choose necessary interval as follows: days 0, hours 1, minutes 0 Choose End Options > Forever. If you select Forever, the Integration Service schedules the workflow as long as the workflow does not fail. Save the workflow. Schedule the workflow. To schedule the workflow: Open the Navigator. Navigate to the workflow. Right-click and schedule the workflow.

P.S. Man kann das auch mit eine Decision tun.

https://kb.informatica.com/howto/2/Pages/104712.aspx?myk=scheduler%20end%20time

Montag, 13.06.2016