Informatica PowerCenter
版本 : 8.6.1 HotFix10

stop
pmcmd stopworkflow -sv is_name -d Domain_name -u user_id -p password -f "folder_name" -wait wf_name

启动workflow
pmcmd startworkflow -sv is_name -d Domain_name -u user_id -p password -f "folder_name" -wait wf_name

启动session

PMCMD starttask -sv Integration_Service_Name -d Domain_Name -u User_Name -p Password -f "Folder_name" -w Workflow_Name Session_Name -wait

ScheduleWorkflow

PMCMD ScheduleWorkflow -sv Integration_Service_Name -d Domain_Name -u User_Name -p Password -f "Folder_name" -w Workflow_Name Session_Name -wait

把这些语法,放在run.bat

getworkflowdetails

wf detail就会输出存在我们指定E:\test\xx.log的档案里

PMCMD getworkflowdetails -sv Integration_Service_Name -d Domain_Name -u User_Name -p Password -f "Folder_name" Workflow_Name > E:\test\xx.logpause

starttask

一个一个点很麻烦,写成bat按一下就好
-wait 第二行,会等第一行执行完才会跑

PMCMD starttask -sv Integration_Service_Name -d Domain_Name -u User_Name -p Password -f "Folder_name" -w Workflow_Name Session_Name -waitpause

另一种写法,拆2个档案(变数+执行档)

变数档E:\test\PC_Login.cmd

SET Service=Integration_Service_NameSET Domain=Domain_NameSET User=User_NameSET Password=PasswordSET temp=E:\test\ REM *** Set FolderName and WorkflowName ***SET s1="Folder_name"SET s2=Workflow_Name

执行档run.bat

@ECHO OFF REM *******************************************************REM * File   :  REM *REM * This script starts a workflow and checks for run status.REM * 输入两组参数 Folder名称以及 Workflow名称REM *REM *******************************************************REM *** Get variables from PC_Login.cmd ***CALL E:\test\PC_Login.cmdSET Service=%Service%SET Domain=%Domain%SET User=%User%SET Password=%Password%SET temp=%temp%REM *** Set FolderName and WorkflowName ***SET Folder=%s1%SET Workflow=%s2%REM *** Start Workflow and wait till workflow completes ***PMCMD startworkflow -sv %Service% -d %Domain% -u %User% -p %Password% -f %Folder% -wait %Workflow% REM *** Return the information about a workflow in a tmp file ***PMCMD getworkflowdetails -sv %Service% -d %Domain% -u %User% -p %Password% -f %Folder% %Workflow% > %temp%%Folder%.%Workflow%.logREM echo %Service%REM echo %Domain%REM echo %User%REM echo %Password%REM echo %temp%REM echo %s1%REM echo %s2% pause

ref
http://idwbi.com/pmcmd-commands-in-informatica/