Results 1 to 2 of 2
  1. #1
    Join Date
    May 2005

    Unanswered: SQL Agent 2005 job fails if logged off

    I have a job scheduled to run daily every hour. If I log on to the server the jobs runs sucessfully but if I log off the job fails. I have scheduled a SSIS package to run as a job.. pLease help...

    I am using SQL Server 2005. and a proxy account to run the job. I treid to run the job as One Time only and it runs sucessfuly.

  2. #2
    Join Date
    Mar 2007
    Holmestrand, Norway
    Have you checed the credentials under which the scheduled package runs? I seem to remember that a job starded manually runs as the user who starts it, but I might be proven wrong.
    Ole Kristian Velstadbråten Bangås - Virinco - - Facebook - Twitter

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts