Create DBMS Jobs
-
From the Home screen, select Administration > Global Setup > DBMS Jobs, and click Create Job.
-
Type the DBMS job code and add a comment.
-
Select an interval for execution of the job from the Interval list.
-
Select a start date for the job.
-
Type a SQL query in Executed Statement cell to execute when the DBMS job is run, and then click Create.
View or edit a DBMS job details
-
From the DBMS Jobs screen, select a job.
-
Type the changes to the SQL query in the Executed Statement cell in the Parameters section.
-
Select Broken in the Parameters section to specify that the DBMS job/SQL query is broken and that the automatic job execution is disabled.
-
To run the DBMS job, click Run Now.
-
To set up a new Oracle job process, click Install.
-
To view the log file associated with the DBMS job, click the file name in the Log Files block.