You can define an SQL (SQL_JOB) job to run an SQL query against an Oracle, Microsoft SQL Server, or IBM DB2 database. When the job runs, the SQL statement is invoked and the results are stored in an output file or job spool file. You can also add criteria to the job definition to test the query result. If the result matches the criteria, the job completes. Otherwise, the job fails.
Note: To run these jobs, your system requires CA WA Agent for UNIX, Linux, or Windows and CA WA Agent for Databases.
Required Statements
To define an SQL job, you must specify the following statements:
Note: All database jobs require a database user ID and the database resource location. You can use the defaults defined on the agent in the agentparm.txt file or specify the USER and DB_URL statements in the job definition.
Optional Statements
You can specify the following optional statements for an SQL job:
|
Copyright © 2013 CA Technologies.
All rights reserved.
|
|