Create an Oracle job with a global temporary table during Oracle statistics

1. Create an Oracle global temporary table. The Code is as follows:
SQL code

1. DECLARECntInt;
2. Begin
3. -- If the temporary table exists, delete it.
4. SELECT Count(1)IntoCntFromUser_tablesWhereTable_name ='Templogsmshall _ session';
5. If cnt> 0THEN
6. BEGIN
7. ExecuteImmediate'Drop TABLE TEMPLOGSMSHALL_SESSION';
8. END;
9. EndIf;
10. End;
12. /
13. -- Create a temporary table
14. CREATE GLOBAL TEMPORARY TABLETempLogSmsHall_Session (
15. SESSIONID VARCHAR2 (28)NOT NULL,
16. USERTELNO VARCHAR2 (16)NOT NULL,
17. USERCITYNAME VARCHAR2 (8)NOT NULL,
18. USERBRANDNAME VARCHAR2 (16)NOT NULL,
19. NLIBIZNAME VARCHAR2 (32)NOT NULL,
20. BIZNAME VARCHAR2 (128)NOT NULL,
21. OPERATIONNAME VARCHAR2 (16)NOT NULL,
22. SCENEHANDLETYPE VARCHAR2 (32)NOT NULL,
23. SCENEHANDLEID VARCHAR2 (6)NOT NULL,
24. SESSIONBEGINTIMETIMESTAMPNOT NULL,
25. SESSIONENDTIMETIMESTAMPNOT NULL,
26. ISTIMEOUTCHAR(1)DEFAULT '1' NOT NULL,
27. ALLCOSTSECONDSINTEGERDEFAULT(0)NOT NULL,
28. REVSMSNUMINTEGERDEFAULT(0)NOT NULL,
29. SENDSMSNUMINTEGERDEFAULT(0)NOT NULL
30. )
31. ON COMMITPRESERVEROWS;

The temporary table created above is independent of each stored procedure or PL/SQL block that calls it and does not affect each other. That is to say, two PL/SQL statements can be called at the same time, and the result pages will not affect each other.

2. Create an Oracle job with the following code:
SQL code

1. DECLAREJob NUMBER;
2. Begin
3. Dbms_job.submit (job => job,
4. What =>'Ecss _ JOB. SMSS10_Job_DailyStatus ('''');',
5. Next_date => trunc (sysdate) + (1 + 1/24 ),
6. Interval =>'Sysdate + 1');
7. Commit;
8. End;

Where: job is the number automatically generated by the system, ECSS_JOB.SMSS10_Job_DailyStatus is a process (there is also a string parameter), next_date sets the next execution time, here is tomorrow morning, interval sets the interval, how long is the execution performed every day. The trunc function is used to remove the time in the date, that is, to get the of a day. The time is in the unit of day. Therefore, to get a score of, you need to score:

1/24 hour;
1/1440 points;
1/3600 seconds;

In addition, note that the SQL statement should not be executed multiple times, and several jobs will be submitted after the SQL statement is executed several times.