Microsoft SQL Server tasks require only the full query. You can use all syntax and language constructs accepted by the target SQL Server, against which the query will be executed by the agent. The query can be written manually into the editor, or uploaded from a local .sql file by using the BROWSE FOR A FILE... button.
|
WARNING RayVentory Data Hub uses a loose structure of the data and does not enforce any particular security and access rights in terms of what the reporting queries are doing. Since temporary tables are sometimes necessary and may be deleted afterwards, commands such as "delete", "drop", "update" are permitted. Thus, improper use can lead to data loss in the database source. Make sure that the query does not damage other reporting data by only removing or changing the tables owned by the report. |
