March 12, 2009 at 10:16 am
sorry for this question. i'm a sql2k5 novice and can not find the answer to this.
i've created a maintenance plan and selected "Select Report Option" and specified a PATH where TEXT files will be written to. This works fine. But, I need to change that PATH. Where in the Maintenance Plan/Job can I find the "Select Report Option" to change where the TEXT file will be written to?
...thanks
March 12, 2009 at 11:56 am
In the Maintenance plan if you click on the icon with in Maintenance window design the very last icon before "Servers..." (Reporting and Logging).
You can set the path there, by default it is MSSQL.1\MSSQL\Log
Thanks.
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
March 12, 2009 at 12:05 pm
THANK YOU SO MUCH !!!
I couldn't find that for the life of me.
I have no sql2k5 training and due to our wonderful economy I was told I wasn't going to get any training. So, I rely on BOL, the WEB and you good folks.
thanks again
🙂
March 12, 2009 at 12:45 pm
Any time... if it wasn't for newsgroups, forms, and many many blogs I follow .. I did be a lost too.
People on this form are great, some great people respond here; some of being Microsoft MVP an all :D.
So post away and ppl will answer if they know anything 😎
Thanks.
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply