Currently, the popular mainstream database has this feature, the most representative of Microsoft SQL Server 7.0, oracle8i/9i, and so on. However, to make the job work, we need to configure it to be implemented. These configurations all have GUI
One, start the process that executes the jobIn Oracle, it is a background process that uses the job queue of the job queue coordination process (CJQ0), which coordinates the database instance, to monitor the job table (job$) in the job queue and to
Oracle job description 1. set the initialization parameter job_queue_processes SQL> alter system set job_queue_processes = n; (n> 0) job_queue_processes. The maximum value is 1000. view the SQL> select name of the job queue background process,
1. Set the initialization parameter job_queue_processes.SQL> alter system setjob_queue_processes = N; (n> 0)Job_queue_processes: the maximum value is 1000. View the Job Queue background processSQL> select name, description fromv $ bgprocess; 2.
Oracle JOB usage Summary 1. set the initialization parameter job_queue_processes SQL> alter system set job_queue_processes = n; (n> 0) the maximum value of job_queue_processes is 1000. view the SQL> select name of the job queue background process,
In the single terminal interface of Linuxbashshell for job switching and offline management in the front and backend of Linux, we often need to manage or complete multiple jobs at the same time, such as performing compilation while implementing data
In project development, we often have complicated business logic. Using the stored procedures of Oracle can greatly reduce the compilation workload of Java program code, and the stored procedures are executed on the database, so that the good
Before using Linux will always accidentally press CTRL + Z, and then appear to understand the situation, thinking that the program suddenly did not, today specializes in the next Linux under a few shortcut keys and work management.One of them found
Oracle
Discussion on Oracle Job (Job) Update next_date
The author of this article: Kamus (Kamus@itpub.net)
Summary: This article analyzes the mechanism for modifying the next execution time during Oracle job execution through experiments and
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.