Question:
We are trying to schedule a job that would launch SSIS package job from a DSTX file rather than a definition in the SQL scheduler. How to code SSIS package job thru CA Workload Automation ESP Edition?
Environment
CA WA ESP Edition 11.4 Z/OS
Answer:
There are two ways:
1. Use cmd.exe on CMDNAME, like:
CMDNAME C:\windows\system32\cmd.exe
ARGS /C "DSTX_file_and_parms"
2. Add the DSTX in the .cmd file.
Additional Information:
N/A