Post reply

Scheduled jobs now failing

  • May 6, 2004 at 7:19 am

    #108240

    I have export jobs that previously have been executing without any errors. Now, these jobs are failing. I am getting the following error: Error = -2147467259 (80004005) The error string shows the path that I want the download to go to and states that this is a not a valid path. When I go to local packages and execute the job from there, it runs without any errors.

    Any suggestions?

    Much thanks.

  • May 7, 2004 at 6:34 am

    #505652

    If the job runs when you run it from local packages but not when scheduled it's probably a security issue.. check that the account the SQL agent runs under has appropriate permissions on the network resource that the job is trying to access.

  • May 7, 2004 at 8:09 am

    #505670

    Thanks for your response.  It turns out that someone had logged onto this server but was not logged onto the proper domain.  The mapped drives that the export jobs were trying to get to were not there.

    Thanks again!

     

     

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

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