I am facing an issue like ( Submit Error, bad or no defn ) for a NT_JOB. Event is schedule to trigger on every 15 minutes .
If i clear all the older generation - it's running fine for the 1st trigger and from 2nd time trigger onward facing this issue.
Can you please help me solve this problem.
Code is here :
-------------------
NT_JOB P49MCUBL +
LONGNAME(champ_cube_builder)
/* Job for Monthly and Weekly Cube Builder */
RUN ANY
TAG NTPTR1
AGENT ESPPPLYSSQL288P
USER INTERNAL\plyasvc-champ_user
CMDNAME "D:\MSSQL\100\DTS\Binn\DTExec.exe"
ARGS /F "D:\Pharmatrend\Germany_Production_Packages\+
CUBE BUILDER\AS_MASTER.dtsx"
ENVAR STDERR="D:\Pharmatrend\Germany_Production_Packages\+
CUBE BUILDER\ETLCubeLoadExecutionLog.txt"
ENVAR STDOUT="D:\Pharmatrend\Germany_Production_Packages\+
CUBE BUILDER\ETLCubeLoadExecutionLog.txt"
RESOURCE ADD(100,PFENNT_PTR_P49_DE)
RESOURCE ADD(100,PFENNT_PTR_CHAMP_XX)
PRIORITY 98
EXITCODE 1-9999 FAILURE
EXITCODE 0 SUCCESS
NOTIFY FAILURE MAILBOX(CSPRODUKTION)
ENDJOB