Post reply

DTS Package hangs and run for ever when Schedule as a JOB

  • March 30, 2009 at 2:22 pm

    #72604

    I havea simple DTS package which execute a .bat file on local server

    EXECUTE PROCESS TASK has the content below

    D:\datafiles\tab\Push.bat

    Push.bat has the following content, its basically delete bunch of old files and than zip new ones using alzip utility

    del D:\datafiles\tab\filson.zip

    alzip -a "D:\datafiles\tab\*.csv" "D:\datafiles\tab\Filson.zip

    package runs fine manually and takes two minutes to complete.

    My probelm is this DTS package when schedule as SQL JOb it hangs and run for ever.

  • March 30, 2009 at 9:46 pm

    #968843

    Hello,

    Is this issue possibly related to permissions of the Account under which the SQL Server Agent Service runs?

    One way to test this theory out is to temporarily change the SQL Server Agent Service to run under the same account that you used when you successfully manually executed the Package.

    Regards,

    John Marsh

    www.sql.lu
    SQL Server Luxembourg User Group

Viewing 2 posts - 1 through 1 (of 1 total)

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