Create and delete jobs in PL/SQL

1. Learning jobs in PLSQL
3. -- Learning job
4. -- Create a table
5. Create Table test_job (para_date
   Date );
6. Commit;
8. Insert into test_job
   Values (sysdate );
9. Commit;
10. Select * From test_job;
    
13. -- Establish the storage process
15. Create or
    Replace procedure test_jobproce
    As
17. Begin
19. Insert into test_job
    Values (sysdate );
21. End test_jobproce;
23. -- Create a job
24. -- After a job is created, it is executed by default.
26. Declare test_job_really number;
    
27. Begin
28. Dbms_job.submit (test_job_really, 'test _ jobproce; ', sysdate, 'sysdate + 100 ');
    
29. Commit;
30. End;
33. --- Stop job 25 is the created job test_job_really
    
34. Begin
35. Dbms_job.broken (25, true );
36. Commit;
37. End;
40. -- Start job
41. Begin
42. Dbms_job.run (25 );
43. Commit;
44. End;
47. -- Delete a job
49. Begin
51. Dbms_job.remove (25 );
52. Commit;
53. End;
55. -- View execution results
56. Select * From test_job
    Order by test_job.para_date
    DESC;
58. -- View job
59. Select * From SYS. user_jobs
    
61. -- Use the following SQL statement to check whether the job is still running, provided that the job execution time is not too short.
    
63. Select * From dba_jobs_running
    
68. In addition to the submit parameter, the following parameters are available:
70. Dbms_job.run (v_job); // run the job
72. Dbms_job.broken (v_job, true, next_date); // stop a job. The true parameter in the job is also false, and next_date (stops at a certain time) is sysdate (stops immediately ).
    
74. Dbms_job.remove (v_job); // deletes a job.
76. Dbms_job.what (v_job, 'SP _ fact_charge_code; '); // modify a job name
    
78. Dbms_job.next_date (v_job, sysdate); modifies the next running time