how to schedule sqldoc CLI
I can run sqldoc CLI and generate proper documentation. I can even schedule with TaskScheduler.
But if I try to use an alternate scheduler I get this error (among others):
"Showing a modal dialog box or form when the application is not running in UserInteractive mode is not a valid operation. Specify the ServiceNotification or DefaultDesktopOnly style to display a notification from a service application."
the command line call looks like this:
sqldoc.exe /q /server:thedb /out:c:\to\some\path.log /force /of:c:\thedocs
Anyone know how to tell the command line version of sqldoc to not create a winform window?
But if I try to use an alternate scheduler I get this error (among others):
"Showing a modal dialog box or form when the application is not running in UserInteractive mode is not a valid operation. Specify the ServiceNotification or DefaultDesktopOnly style to display a notification from a service application."
the command line call looks like this:
sqldoc.exe /q /server:thedb /out:c:\to\some\path.log /force /of:c:\thedocs
Anyone know how to tell the command line version of sqldoc to not create a winform window?
Tagged:
Answers
To use SQL doc in an automated fashion you will have to use the command line within SQL Change automation as standalone SQL Doc does not support this.