1.

Start ODI Designer: Start > All Programs > Oracle > Oracle Data Integrator > Designer. Select WORKREP from the Login Name drop-down list if not already selected. Enter SUPERVISOR as the User name and SUNOPSIS as the Password. Click OK to log in.

2.

In ODI Designer, click the Projects tab. On the Projects tab, expand the project: ODIcreate_table > First Folder > Procedures. Right-click the PRGcreate-populate_table procedure and select Generate Scenario.

Name the scenario CREATE_AND_POP_SALES_PERSON. Set the Version to 001. Click OK.

Expand the PRGcreate-populate_table procedure and expand Scenarios. Right-click the CREATE_AND_POP_SALES_PERSON scenario to view the possible options as shown in the following screenshot.

Note: The scenario has now been successfully created. You can now execute the scenario directly, use the scenario within a package, or schedule the package within ODI.

Open the Services window (select All Programs > Administrative Tools > Services) and stop the Oracle DI Agent service if started. Close the Services window.

2.

Open (if not opened ) the Oracle XE Database Home page: Start > All Programs > Oracle Database 10g Express Edition > Go To Database Home Page. The Login screen appears. Log in to the database as user ODI_STAGE3. The password for this user is password.

On the Oracle Database 10g Express Edition Home screen, select SQL Commands > Enter Command from the SQL drop-down list. Enter and run the statement that is provided below. If the SRC_SALES_PERSON table exists, it is dropped. Otherwise, the message "table or view does not exist" is displayed.

drop table ODI_STAGE3.SRC_SALES_PERSON

4.

Open the Command window and change the directory to the ODI_HOME\bin directory (for example, I:\ODI\oracledi\bin). To start ODI Agent as a scheduler, execute the agentservice.bat file by using the following command:

agentscheduler.bat –NAME=localagent

Note: To perform this step, an ODI Agent must be set up. To set up an ODI Agent, see the OBE titled Setting Up and Installing an ODI Agent as a Background. To access this OBE, click HERE.

5.

Expand the PRGcreate-populate_table procedure. Expand Scenarios > CREATE_AND_POP_SALES_PERSON. Right-click Scheduling, and then select Insert Scheduling.

Note: If an ODI Agent is not set up within the ODI Topology Manager, the following error message appears: "To use the scheduling, please set an agent in your repository." To schedule a scenario, an Agent must be set up. To set up an ODI Agent, see the OBE titled Setting Up and Installing an ODI Agent as a Background. To access this OBE, click HERE.

On the screen that follows, select the agent where the scheduled scenario will run: localagent. Set Context as Global and log level to 5. Set Execution to Simple and click the button. Set the execution time to approximately 5 minutes from the current system time as shown in the following screenshot. Click OK. Click OK again.

Expand Scheduling and verify that the localagent entry is now inserted under Scheduling.

Click the icon to start Topology Manager to review the scheduling of the Agent. Expand the Agents node, right-click localagent, and select Edit. On the Agent: localagent screen, click Update Scheduling. On the screen that follows, click OK.

Click the Scheduling information button. The screen that appears shows you the scheduling information.

1.

To verify that your scheduled scenario was executed successfully, you need to open ODI Operator. Click the ODI Operator icon on the menu bar to start ODI Operator. In ODI Operator, click the Session List tab . Expand Date > Today > CREATE_AND_POP_SALES_PERSON, and view the execution results for the PRG_create-populate_table procedure.

2.

Expand Physical Agent > localagent > CREATE_AND_POP_SALES_PERSON, and view the execution results for the PRG_create-populate_table procedure. Note the execution time of this scenario, that is, the time that you scheduled with ODI Agent. You have now successfully scheduled a scenario with an agent scheduler. The scenario was executed by the agent successfully.

Note: If you want to execute the procedure again, you must first drop the SRC_SALES_PERSON table as described in step 2 of the "Scheduling a New Scenario with Oracle Data Integrator" section.