Oracle Job Queue/Oracle Job Queue

I. Job ConceptA group of PL/SQL statements used to complete specific functions. It is written by industry experts, and can compare it with our work schedule in our daily work. It will start to work at a certain time in the future, or manually repeat the rows after each interval. Ii. Job, Job Queue, jnnn, Coordinator Job Queue (cjq0) , Dbms_jobJob Queue is translated into Chinese and is called an operator column. A group of slave PL/SQL statements is used to complete specific functions. An operator column is a kind of mechanism or component used in the Oracle server for operation. Jnnn refers to the operation progress of a specific job, And NNN refers to the operation progress. Cjq0 is an improvement of the business process. It is also an improvement of the business process, and its role is to use jnnn. Dbms_job is a package in which procedures are used to manage the operation, including adding a job to the operation column, remove an operator from the assignment column, and immediately modify the assignment in the assignment column as the description in the assignment column, modify the duration of the job in the industry column. Iii. Attention PrincipleYou can add an operator column to the operator column by using the procedures in the dbms_job package through the operator and set the operation duration or period. Cjq0 starts to check whether there is a peak time in the homework column. If it appears, to assign a job execution process jnnn. Iv. Operation Evaluation Function of Dynamic Data ProcessingSet the initialization parameters Job_queue_processesThis function allows you to create an animation. If job_queue_processes is set to 0, the job in the job column will not be automatically written. When the job_queue_processes value is greater than 0, the dynamic operation degree function is enabled. Job_queue_processes refers to the number of business processes. For example, job_queue_processes = 30 indicates 30 business processes are triggered. Job_queue_processes is an automatic snapshot number, which can be modified at runtime through the alter system command. For example: Alter system set job_queue_processes = 20 if the new value is smaller than the original value, and the number of blank operation processes is less than the difference between the two, the blank job progress will be stopped, but it will not immediately stop the job progress in the production line. Instead, it will wait until the production line is finished. V. Manage the assignment Column1. The following is the process description in the dbms_job package. (Note: The manual description of the dbms_job package. Please refer to the official Oracle document .) <Supplied PLSQL packages and types reference>): Procedure description ---------------------------------- submit is used to add an assignment to the assignment column to remove change from the assignment column to modify the description and degree of operation specified in the assignment column. what is the time or period used for the preset operator column to specify the operator's job generation? next_date: Modify the operator column to specify the operator's next operation time. interval: Modify the operator column to specify the operator's role. determines whether the operation is "broken" in the broken settings column between the row cycles ", if the job is running in the "broken" example, it will not be specified in the response column of the execution row run immediately. -------------------------------- 2. example Submit an assignment to the assignment ColumnVariable jobno numberbegindbms_job.submit (: jobno, 'dbms _ DDL. analyze_object (''table'', ''hr'', ''ployees '', ''estimate'', null, 50); ', sysdate, 'sysdate + 1'); Commit; end;/print jobno JOBNO----------14144 the previous generation submits a job to the job list, the business representative is dbms_ddl.analyze_object (''table'', ''hr'', ''ployees '', ''estimate'', null, 50 ); the primary row time is sysdate, and the primary row cycle is one row per day. Start a job nowRun dbms_job.run (14144 ); Modify a job (Change 14144 RMB to three-day renewal. )Execute dbms_job.change (14144, null, null, 'sysdate + 3 '); 6. view the information in the assignment ColumnYou can view the previous job information by using the following example: dba_jobsall_jobsuser_jobsdba_jobs_running operation details. Please refer to <Oracle9i Database reference>.