run job in background

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,

Declare X number; Begin SYS. dbms_job.submit (Job => X, What => 'etl _ run_d_date ;', Next_date => to_date ('2017-08-26 01:00:00 ', 'yyyy-mm-dd hh24: MI: ss '), Interval => 'trunc (sysdate) + 1 + 123 ', No_parse => false ); SYS. dbms_output.put_line

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