Informatica Job's through both Windows and Linux/Unix can be automated and managed through JAMS by creating a simple Job, or creating a template with an Execution Method.
Informatica for Windows
Below is an example of a Windows Batch script utilizing PMCMD.exe. The Execution Method used would be Command, ensuring you have the Windows Agent installed on the target Informatica server and defined within the Job's Properties.
The Source of the Job would contain the Windows batch script that might look something like below.
pmcmd startworkflow -sv MyIntService -d MyDomain -u seller3 -p jackson -f SalesEast wf_SalesAvg
Any operations that could be performed through PMCMD.exe could be executed using a JAMS Job.
Here is a link to the command line reference for using PMCMD from Informatica's support site.
Informatica for Unix
Below is an example of a shell script utilizing PMCMD. The Execution Method used would be SSHAgent, ensuring you have JAMSAgentX installed on the target Informatica server and defined within the Job's Properties.
Any operations that could be performed through PMCMD could be executed using a JAMS Job.
#!/usr/bin/bash # Sample pmcmd script # Check if the service is alive pmcmd pingservice -sv testService -d testDomain if [ "$?" != 0 ]; then # handle error echo "Could not ping service" exit fi # Get service properties pmcmd getserviceproperties -sv testService -d testDomain if [ "$?" != 0 ]; then # handle error echo "Could not get service properties" exit fi # Get task details for session task "s_testSessionTask" of workflow # "wf_test_workflow" in folder "testFolder" pmcmd gettaskdetails -sv testService -d testDomain -u Administrator -p adminPass -folder testFolder - workflow wf_test_workflow s_testSessionTask if [ "$?" != 0 ]; then # handle error echo "Could not get details for task s_testSessionTask" exit fi
Comments