Setting up a job for a .cmd file, that triggers a .dtsx file - Public service announcement

[Marilyn Singley]

Had a client request an Automic job running a .cmd file, that inside it triggers a .dtsx file. 

Wanted to share, in case anyone else has issues with this. 

In the windows tab 

Interpreter type = Batch

Batch Mode = log on as batch user

Use Windows OS job object = yes

In the process tab before the file location, add cmd.exe /c "\\servername\folder*\information\**.cmd 

without the /c  the job would run, however it didn't allow the .dtsx file inside the .cmd file to trigger. 

Wanted to put this out here, maybe save someone else a day of trying to figure it out. 

Appreciate all the time this community has saved me time and trouble. 

[Michael Dolinek]

Hi @Marilyn SIngley

As I do not know what your CMD-file is doing and what you mean by "triggering a dtsx-file", I can only assume that inside your CMD-file a program is started that uses a dtsx-file as input.

I would use Window's CALL command to execute a BAT or CMD file in a JOBS for Windows. As an alternative you could also use AE's Job Messenger.

The example shows both options. Every time the CMD-file "c:\tools\MyCmd.cmd" is executed and the current RunID is given as a parameter.

!----------------
! option 1: use call
call "c:\tools\MyCmd.cmd" &$RUNID#

! ------------------
! option 2: use Job Messenger
&UC_JOBMD CMD=""c:\tools\MyCmd.cmd" &$RUNID#" 

see https://docs.automic.com/documentation/webhelp/english/AA/24.2/DOCU/24.2/Automic%20Automation%20Guides/Content/AWA/AdministrationPerspective/AG_Agent_JobMessenger.htm 

Hope this helps

Michael

------------------------------
Michael K. Dolinek

Engineering Program Manager | Agile Operation Division
Broadcom Software
------------------------------