AX2561

Scheduler task: Execute SQL Command

This task runs a SQL statement on an Axiom database. If needed, you can also use this task in a user-defined job to run any valid SQL statement on an Axiom database.

NOTE: The SQL statement in this task will be run as the Axiom database user, regardless of which user executes the job.

This task has the following settings:

Item	Description
Source Axiom Database	Select the database on which to run the SQL statement: Current system database: The database for the current system. Current audit database: The corresponding audit database for the current system.
SQL Command Text	Enter any valid SQL statement to be run against the specified database. To validate the syntax of the SQL statement, click the Check SQL syntax button . Axiom Software sends the statement to your database server to see if the statement can be parsed, resulting in either a success message or an error message. Job variables can be used in the SQL statement. The Check SQL syntax button is not available if the statement uses variables.

Item

Description

Source Axiom Database

Select the database on which to run the SQL statement:

Current system database: The database for the current system.
Current audit database: The corresponding audit database for the current system.

SQL Command Text

Enter any valid SQL statement to be run against the specified database.

To validate the syntax of the SQL statement, click the Check SQL syntax button . Axiom Software sends the statement to your database server to see if the statement can be parsed, resulting in either a success message or an error message.

Job variables can be used in the SQL statement. The Check SQL syntax button is not available if the statement uses variables.