Query setup actions

Use the Query setup actions to build the query string that is run against the application databases that you connected to in the application setup.

Before, you can run a query against the application databases, you must build an SQL query string. When you run the actions in this category, Maintenance Manager appends the corresponding SQL code to the current query string. For example, running QuerySetStatus("hold") followed by QuerySetOperator("admin") generates the following query string.

Select * FROM JobMonitor WHERE queue.qu_status IN ('hold') AND qstats.qs_op IN ('admin')