Post reply

HELP - scheduled DTS jobs fail

  • July 2, 2004 at 2:09 pm

    #108542

    I can run any DTS job immediately just Fine but all of mny DTS jobs fail without a real error.

    When I look in my event viewer, all it says is that the job failed on step 1.

    Win 2k with SQL server 2k.

    Ideas?

    Thanks

  • July 3, 2004 at 12:58 pm

    #513243

    Generally, this is a permissions issue.  Does the owner of the job have permissions to do everything the DTS package needs to do?

    Derrick Leggett
    Mean Old DBA
    When life gives you a lemon, fire the DBA.

  • July 5, 2004 at 9:25 am

    #513332

    Check to see what account SQL Agent runs under.  Most likely, it does not have permission to execute the job.

  • July 5, 2004 at 10:49 pm

    #513380

    This generally happens due to the permission problems and you can use the following SP to reassign the right to user for executing the DTS:

    sp_reassign_dtspackageowner [@name =] 'name',

    [@id =] 'id',

    [@newloginname =] 'newloginname'

    This may solve your problems.

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

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