Optimization Maintenance Plan error

  • Hi All,

    I have an issue with our maitenance plan. The maintenance plan does the rebuild index every week on Sunday. It runs through our third party tool. Now the issue is the job is running fine but the log file is not getting created. I saw the job ran successfull in tool. but from the maintenance plan history it give an error as below.

    Access to the path 'D:\\Program Files\\Microsoft SQL Server\\MSSQL.1\\MSSQL\\LOG\\Update Stats Maint Plan_Subplan_1_20090905224015.txt' is denied.

    Tha account by which the job runs has sa and admin rights on the server. I think the path itself wrong like there is a lot of extra slashes in the UNC path. Not sure where to modify this path. FYI: the same maintenance plan on other server runs fine and generates log file.

    Anyone has suggestions or an idea on this issue.

    Thanks in advance,

    Kiran

  • Hi Kiran,

    You are right. Tha path the log file is incorrect. Just instead of using two slashes use only one slash i.e instead of using C:\\ use C:

    To modify this double click on the Maintenance Plan, Go to Steps and double click on the job step, then go to advanced Tab and then modify the path in the "Output File" box. You can just select the log file using the browse button instead of manually typing the path. Save the changes made to the maintenance plan.

    Thank You,

    Best Regards,

    SQLBuddy.

  • Hi,

    Thanks for your quick reply. The job is not running through SQL agent to modify the path in job setup. It is running through our third party tool which uses the batch file to run the maintenance plan. I tried to find the log path in our tool also but couldn't find. I am wondering that, the same maintenance plans are running fine on other servers.

    Do you have any idea on this?

    Thanks,

    KKK

  • Hi Kiran,

    Actually you have to follow the steps I have outlined previously. The path for the log file is found in the Maintenance plan not in the jobs. Each Step in the Maintenance plan is saved as a SQL server agent job. So whenever you modify the step in the maintenance plan and save the maintenance plan those changes get reflected in the jobs. Its doesn't matter how you are running the job. So follow the steps I have mentioned earlier. Just give it a try. You will succeed.

    Thank You,

    Best Regards,

    SQLBuddy.

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

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