Montag, 13. Juni 2016

PMCMD Command Usage in Informatica

http://www.folkstalk.com/2012/10/pmcmd-command-usage-in-informatica.html
https://informaticadeveloper.wordpress.com/2015/03/25/pmcmd-command-usage-in-informatica/

Informatica provides four built-in command line programs or utilities to interact with the informatica features. They are:
  • infacmd
  • infasetup
  • pmcmd
  • pmrep
This article covers only about the pmcmd command. The pmcmd is a command line utility provided by the informatica to perform the following tasks.
  • Start workflows.
  • Start workflow from a specific task.
  • Stop, Abort workflows and Sessions.
  • Schedule the workflows.
How to use PMCMD Command in Informatica:
1. Scheduling the workflow
The pmcmd command syntax for scheduling the workflow is shown below:
pmcmd scheduleworkflow -service informatica-integration-Service -d domain-name -u user-name -p password -f folder-name -w workflow-name
You cannot specify the scheduling options here. This command just schedules the workflow for the next run.
2. Start workflow
The following pmcmd command starts the specified workflow:
pmcmd startworkflow -service informatica-integration-Service -d domain-name -u user-name -p password -f folder-name -w workflow-name
3. Stop workflow
Pmcmd command to stop the infromatica workflow is shown below:
pmcmd stopworkflow -service informatica-integration-Service -d domain-name -u user-name -p password -f folder-name -w workflow-name
4. Start workflow from a task
You can start the workflow from a specified task. This is shown below:
pmcmd startask -service informatica-integration-Service -d domain-name -u user-name -p password -f folder-name -w workflow-name -startfrom task-name
5. Stopping a task.
The following pmcmd command stops the specified task instance:
pmcmd stoptask -service informatica-integration-Service -d domain-name -u user-name -p password -f folder-name -w workflow-name task-name
6. Aborting workflow and task.
The following pmcmd commands are used to abort workflow and task in a workflow:
pmcmd abortworkflow -service informatica-integration-Service -d domain-name -u user-name -p password -f folder-name -w workflow-name

pmcmd aborttask -service informatica-integration-Service -d domain-name -u user-name -p password -f folder-name -w workflow-name task-name

Montag, 13.006.2013
Eingestellt von um Keine Kommentare:
Labels:

Knowledge Base

https://network.informatica.com/community/informatica-network
https://dwbi.org/etl/informatica
http://www.folkstalk.com/p/informatica-topics.html
https://informaticadeveloper.wordpress.com/

Eingestellt von um 1 Kommentar:
Labels:

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
Eingestellt von um Keine Kommentare:
Labels:
Abonnieren Posts (Atom)