Show parameter job - Display current user's JOBALTER SYSTEM SET JOB_QUE_PROCESS = 10 - Modify System Settings Job_Queue_Processes
Variable Jobno Number; Begin dbms_Job.Submit (: jobno, 'test ();', sysdate, 'sysdate 1/24 * 60'); commit; end; - Add a user Jobselect Job, Next_Date, Next_sec, Failures, Broken from user_jobs; - Query the current user jobbegin dbms_job.remove (3); commit; end; - Delete user jobbegin dbms_job.run (1); commit; end; - Force running a user Job
