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.
The prerequisites to schedule the SQL script files are:
Oracle Database: An instance of Oracle Database is required to schedule the generated SQL script files.
SQL script files: All the generated SQL script files should be deployed to the target or production database host, where they are accessible by the database instance. All the scripts files should be stored together in the same directory.
Oracle Data Miner Repository: The Data Miner Repository is required to run the scripts because some node scripts use the services provided by the Repository at runtime. Some examples of services provided by the Repository are statistic calculation for Explorer node, text processing for Build Text node and so on.
Oracle Data Miner user account: The user account is required to run the script files because it has the necessary grants to the services provided by the Repository.
Complete directory path in the master script file: Add the complete directory path to each node script invocation in the master script. This is required so that the individual node script files can be called by the master script during runtime.
codegen_workflow_Run.sql by editing the master script file.Parent topic: Scheduling Workflow Script Files