Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003
    Posts
    27

    Question Unanswered: maint. plan fails but doens't report error

    Hello

    I have this maint. plan where each and every step has been failing the last couple of days. The problem is, it doesn't write anything to the error logs. It only reports to the application log that each step of the plan has failed.

    I suspect this might be a user rights problem, but it's difficult for me to say. What kind of rights are necessary for writing to the error logs???

    In general, what rights are necessary for the user that runs the SQL Server Agent? And has anybody else experienced something similar?

    MNJ

  2. #2
    Join Date
    May 2003
    Posts
    60
    This is mostly about scheduling a DTS package as a job. However, the security aspect of it should pertain to your situation as well.

    Go Here: http://support.microsoft.com/default...b;en-us;269074 (Microsoft Knowledge Base Article 269074)

Posting Permissions

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