Scheduling Workflow Script Files

All the generated SQL script files must be deployed to the target or production database where they are accessible by the database instance. The SQL script files must be stored together in the same directory.

This section shows how to use SQL Developer and Oracle Enterprise Manager to schedule the master script to run.

• Prerequisites for Scheduling Workflow Script Files
  Before scheduling workflow script files, certain tasks related to Oracle Database, SQL script files, Oracle Data Miner repository and Oracle Data Miner user account must be performed.
• Schedule SQL Scripts Using SQL Developer
  Oracle SQL Developer provides the graphical user interface to define Scheduler Jobs.
• Scheduling SQL Scripts using Oracle Enterprise Manager
  Oracle Enterprise Manager allows Database Administrators to define jobs. The job definition defines the master script invocation as a script file using a full file path.