Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Maintenance Plan reporting Expand / Collapse
Author
Message
Posted Thursday, March 12, 2009 10:16 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, April 08, 2014 10:48 PM
Points: 205, Visits: 1,341
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
Post #674428
Posted Thursday, March 12, 2009 11:56 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Monday, March 10, 2014 9:39 AM
Points: 942, Visits: 1,050
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.
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.


How to ask for help .. Read Best Practices here.
Post #674522
Posted Thursday, March 12, 2009 12:05 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, April 08, 2014 10:48 PM
Points: 205, Visits: 1,341
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

:)
Post #674538
Posted Thursday, March 12, 2009 12:45 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Monday, March 10, 2014 9:39 AM
Points: 942, Visits: 1,050
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.
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.


How to ask for help .. Read Best Practices here.
Post #674586
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse