Post reply

SQL SERVER AGENT 2005 - Task not completing

  • February 2, 2010 at 8:39 am

    #144745

    Hi...I've got an exe and an ssis package..which i am trying to run as 2 steps...Both work when executed manually but when i try to run them as steps within sql agent the first step doesn't seem to end...It does what its supposed to do ie..download a file from a website but never moves on to the next step it just sits on the first step with a status of executing... has anyone had this problem...

    thanks

    Ang

  • February 2, 2010 at 10:55 am

    #1112427

    does the first step actually complete - is the exe still running if you look in task manager?

  • February 2, 2010 at 1:32 pm

    #1112515

    DNA_DBA (2/2/2010)

    does the first step actually complete - is the exe still running if you look in task manager?

    The above is the best thing to check first.

    Another thing you can do is execute the exe from within the SSIS package as the first step. at least that way you can add some auditing and see whats going on

  • February 2, 2010 at 2:43 pm

    #1112539

    Thanks...i'll check 2moz and report back..:-D

  • February 4, 2010 at 5:06 am

    #1113631

    Hi...this seems a bit strange...the exe wasn't running..but what i did change to fix this prob was the onsuccess option...I had it left on the default "go to next step"..but when i changed it to "go to step 2 (the name of step)" it worked...wierd but working...

    thanks

    Ang

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply