Posts mit dem Label scheduling werden angezeigt. Alle Posts anzeigen
Posts mit dem Label scheduling werden angezeigt. Alle Posts anzeigen

Montag, 13. Juni 2016

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.
  1. Create a workflow, WF_schedule.
  2. 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.
  3. 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.
  1. Create a workflow, WF_unschedule.
  2. 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.
  3. 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:
  1. Open the workflow.
  2. 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
  3. Go  to Workflows > Edit > Scheduler.
  4. In the Schedule option, choose necessary interval as follows: days 0, hours 1, minutes 0
  5. Choose End Options > Forever.
    If you select Forever, the Integration Service schedules the workflow as long as the workflow does not fail.
  6. Save the workflow.
  7. Schedule the workflow.
To schedule the workflow:
  1. Open the Navigator.
  2. Navigate to the workflow.
  3. 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