I'm trying to determine how to automate a current and working Query that does diagnostic on our RTUs to daily generate and export that list at a particular time everyday.
Thanks for your assistance guys
Solved! Go to Solution.
In the DataBase Tree, right click, then Create New > Other > Schedule.
Put your Query into a "SQL Export". Setup the Schedule to run Daily, weekly, or Monthly, etc, choose the time. Then drag and drop the SQL Export into the Object portion at the bottom of the Schedule window and choose "Export SQL Query Result" as the method.
An alternative to an "SQL Export" would be a Crystal Report. This gives you more choices over the generated file format, e.g. Word, Excel, PDF, rather than just CSV.
Not much of a need to use a script since most of what you would need to run a report can be accomplished with a schedule. But, I suppose if you wanted to, the biggest thing you would need to know is how declare and call a Method to Execute or Export a SQL Export or a Crystal Report.
Here is a link that might have helpful info. https://tprojects.schneider-electric.com/telemetry/display/public/CS/Reporting