May 4, 2010 at 9:22 am
Hi. We have several SQL 2008 Web edition servers, on those we have maintenance plans to backup the DBs and some other jobs.
On one of the servers there's an odd issue that agent jobs' logs are not being saved to disk. On all other servers, the logs are placed in MSSQL.<instancename>\Log\<MP_plan_name>_<job_step_name>_<datetime>.txt. This required no configuration on our side, it's working fine since we installed them.
On this particular server, the logs are not saved to disk (at least not to the location I would expect and I couldn't find them anywhere), although you can view the history by right-clicking on the job in SQL Agent and selecting "View history".
What's the problem and how to fix it?
Thanks in advance.
May 4, 2010 at 11:13 am
To quickly see where SQL Server is going to (if at all) create the maintenance plan log files open up Management Studio and edit the Maintenance Plan.
In the tabbed window that appears there are a number of menu icons. The 7th one from the left is "Reporting and Logging". Select that one and a properties page appears showing an option to create a text log file and where the log is to be created.
May 4, 2010 at 3:41 pm
Thanks Spencer, exactly what I was looking for.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply