Oracle job process solves the problem of no automatic execution

Oracle job process solves the problem of no automatic execution

It's easy to create a job. Here we mainly talk about the problem that the job is not automatically executed according to the specified time.

Solution:
1. Run the job
Begin
Dbms_job.run (1); // indicates the job number, which can be obtained through the select job, broken, what, interval, t. * from user_jobs t; query
Commit;
End;
2. Restart OracleServiceORCL and OracleOraHome90TNSListener.
3. log on to SQL \ plus
4. alter system set job_queue_processes = 20; commit;
5. OK