Output location wrong when running SQL Doc from SQL Agent

Documents SQL Server 2000, 2005 and 2008 databases.

Output location wrong when running SQL Doc from SQL Agent

Postby ebh » Tue Sep 09, 2008 7:04 am

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
Posts: 1
Joined: Tue Sep 09, 2008 6:48 am
Location: Sydney

Postby Linda Hawksworth » Thu Oct 09, 2008 3:11 pm

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.
Linda Hawksworth
Posts: 192
Joined: Mon Jun 25, 2007 10:32 am

Return to SQL Doc Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests