Navigate to the Schedules node in the Design Center Console and create a new Schedules module called MY_SCHEDULES. For the location, select your TARGET_LOCATION, as the schedule will be deployed to the database.
Create a new schedule, TEST_SCH, with time greater than current database machine time (server where the job executes).
Associate your schedule with the mapping or process flow. Right click the mapping or process flow and select the option “Configure” and “set Referred Calendar” to TEST_SCH.
In the Control Center Manager, navigate to your TARGET_LOCATION and note the Scheduled Job TEST_SCH_JOB under the Scheduled Jobs node. Deploy the job with action “Create”.
Using SQLPlus logged into the database as the TARGET user, verify the user has a job TEST_SCH_JOB, in state DISABLED:
select job_name, state from user_scheduler_jobs;
Use the Schedule tab on the Control Center Jobs panel in the Control Center Manager to schedule the job. Highlight, right click the job and from the pop-up menu select “start”. Use the same query to check the current status:
select job_name, state from user_scheduler_jobs;
The above query will show whether the scheduled job is SCHEDULED, RUNNING or SUCCEEDED.