You should test your database connection and SQL statements using the Database Test utility before setting up and scheduling automated SQL tasks here.
SQL statement
Enter your SQL statement here. It can be a select statement or
even an insert, update, delete statement. This field also supports
dynamic variables.
Directory to place Results
Enter the full path name of the directory where you need to put the
SQL query results. Note that the path is case sensitive on unix systems.
Results Filename
Enter the filename for query results. If no filename is entered,
a default filename of your Task Title is used. This field also supports
dynamic variables. Using dynamic
variables, you can save the file to a customized name based on date/time
or username etc...
Append to Filename
If you are regularly querying a database and wish to save each query
to a different filename based on current time/date, choose
the append file option which best suits your query frequency and file naming
needs
Database JDBC driver
For your database, you need to obtain the JDBC driver from your database
vendor or other 3rd party vendor. Many of the database vendors have
free JDBC drivers available at their web site. The JDBC driver is
generally in the form of a .zip or .jar file. You
need to place the JDBC driver in the following folder depending on your
installation method. Then restart the engine and the user interface.
For installs including JVM : ...Automize/jre/lib/ext
For installs without JVM : ...jre/1.3/lib/ext
or JDK1.3/jre/lib/ext etc.. depending on your system
Driver class name
Enter the class name for the driver. This information will be
available in the driver documentation. For Microsoft Access database,
simply enter "access". Also, the JDBC driver required for MSAccess
is included within java itself.
Database Url
Enter the Url connection information. This information will be
available with the Java JDBC driver documentation.
The Url format will vary with vendor, but generally includes the server
name, port, database name, username, password.
Authorization
If your database requires authentication, then select this option and
enter your username and password.
Username
Enter your username if required for database access. It is case
sensitive.
Password
Enter your password if required for database access. It is case
sensitive.