Creating jobs correct methods - Oracle DBA
Oracle (MCQ) questions and answers
Q. Select the correct method for creating jobs.
- Published on 13 Aug 15
Named Program and Schedule
All mentioned above
ANSWER: All mentioned above
Oracle DBA (
Oracle Replication (
Oracle Architecture (
Oracle Transaction (
Administering and Managing an Oracle Database (
Managing Oracle Database Processes (
Oracle Control Files (
Oracle Redo Log (
Oracle Tablespaces (
Oracle Datafiles and Tempfiles (
Oracle Managed Files (
Oracle Schema (
Oracle Tables (
Oracle Indexes and Partitioned Tables (
Oracle Clusters (
Oracle Views, Sequences, and Synonyms (
Oracle Distributed Database concepts (
-Posted on 25 Aug 15
-The following are the methods for creating jobs
-Named Program - A job can be created by pointing to a named program instead of inlining its action.
-We must specify the value for the program_name in the CREATE_JOB procedure when creating the job and do not specify the values for job_type,job_action and number_of_arguments.
-Named Schedule - A job can be created by pointing to a named schedule instead of inlining its schedule.
-We must specify the value for schedule_name in the CREATE_JOB procedure when creating the job and do not specify the values for start_date, repeat_interval, and end_date.
-Named Programs and Schedule - A job can also be created by pointing to both a named program and a named schedule.
-For example, the following CREATE_JOB procedure creates a regular job called my_new_job3, based on the existing program, my_saved_program1, and the existing schedule, my_saved_schedule1:
job_name => 'my_new_job3',
program_name => 'my_saved_program1',
schedule_name => 'my_saved_schedule1');
Post your comment / Share knowledge
Enter the code shown above:
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)