Red Gate forums :: View topic - Output location wrong when running SQL Doc from SQL Agent
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Doc 1
SQL Doc 1 forum

Output location wrong when running SQL Doc from SQL Agent

Search in SQL Doc 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
ebh



Joined: 09 Sep 2008
Posts: 1
Location: Sydney

PostPosted: Tue Sep 09, 2008 8:04 am    Post subject: Output location wrong when running SQL Doc from SQL Agent Reply with quote

I've created a SQL Doc project, D:\RedGate\SQLDoc\Bob.sqldoc which is set to output to \\FileServer\IT\Docs\Bob. In the options dialog box the "Append server name and timestamp to output folder" option is clear.

When I run:

"D:\Program Files\Red Gate\SQL Doc 1\SQLDoc.exe" /project:D:\RedGate\Doc\Bob.sqldoc /f

from the command line every thing works fine. However when I run the exact same command as part of a SQL Agent Job a new sub folder is created in \\FileServer\IT\Docs\Bob for each instance it is run with the name of the database and time stamp.

I'm using SQL Doc 1.3.0.596
Back to top
View user's profile Send private message
Linda Hawksworth



Joined: 25 Jun 2007
Posts: 192

PostPosted: Thu Oct 09, 2008 4:11 pm    Post subject: Reply with quote

I have spoken to one of the SQL Doc developers and it seems that the auto append settings are in the registry but should be copied into the project file. There seems to be a problem with this in that the options are overwritten by the registry settings when you actually run SQL Doc. This whole area will be looked at with a view to fixing it in the next release of SQL Doc although I am afriad we currently have no timescales for this release.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group