ESP Workload Automation

  • 1.  Submit Error, bad or no defn

    Posted Dec 04, 2017 03:23 AM

    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
      



  • 2.  Re: Submit Error, bad or no defn

    Posted Dec 04, 2017 08:19 AM

    Hi Kumar, 

    Take a looking the transmitter.log for the agent. It may contain a little more information. 

     

    Since the script is not starting it is usually a problem with one of the two lines below.  It does seem odd that it works once. 

     

    USER INTERNAL\plyasvc-champ_user    (this userid/password not correct)
    CMDNAME "D:\MSSQL\100\DTS\Binn\DTExec.exe"   ( this path not found )