Results 1 to 2 of 2

Thread: Job Fails

  1. #1
    Join Date
    Feb 2002
    Posts
    28

    Unanswered: Job Fails

    Hi,
    I have scheduled a job to run everyday night. The job is failing sometimes and not always with this error.

    OLE DB provider 'SQLOLEDB' reported an error. [SQLSTATE 42000] (Error 7399) [SQLSTATE 01000] (Error 7312). The step failed.

    If I run the job again without changing anything, it runs perfectly.
    What could be the problem?
    Thanks
    P.C. Vaidyanathan

  2. #2
    Join Date
    May 2002
    Posts
    25
    permissions are the problem. your sql agent is running under a different user.. the account you are logged into has permissions to do the job and most likely sql agent doesnt.

Posting Permissions

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