How is a new job submitted to the job queue?
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.
How is a new job submitted to the job queue?
Rating:
The DBMS_JOB.SUBMIT procedure (the SUBMIT procedure is provided with the DBMS_JOB Oracle supplied package) is used to submit a new job to be executed to the job queue. The DBMS_JOB.SUBMIT procedure accepts five parameters and returns the number of a submitted job through the JOB parameter. The following table describes those five parameters:
| JOB | OUT | Unique identifier of the job |
| WHAT | IN | PL/SQL code to execute as a job |
| NEXT_DATE | IN | Next execution date of the job |
| INTERVAL | IN | Date function to compute the next execution date of a job |
| NO_PARSE | IN | Boolean flag that indicates whether or not to parse the job at job submission (the default is false) |
Rating:
Was this information helpful?
Other articles
- What is the syntax for creating an INSTEAD OF trigger?
- What is a DDL trigger?
- What is the trigger restriction on a mutating table?
- What are the development steps for creating a package?
- What is a system event trigger?