Previous Topic: Create a TaskNext Topic: Define a DB Stored Procedure Job


Database Jobs

Database jobs let you automate common database tasks on Oracle, Microsoft SQL Server, and IBM DB2 databases.

Note: To run these jobs, your system requires CA WA Agent for UNIX, Linux, or Windows and CA WA Agent for Databases.

You can define the following database jobs:

DB Stored Procedure

Lets you run a stored procedure.

DB Trigger

Lets you monitor for added, deleted, and updated rows in a database table.

DB Monitor

Lets you monitor for an increase or decrease in the number of rows in a database table.

SQL

Lets you execute an SQL statement.