/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

0 vote289 views1 answer
Reona
SQL
49 votes326 views6 answers
Alter table add column
SQL
0 vote290 views1 answer
Returning with sqlalchemy
SQL
-1 vote285 views1 answer
Ssql to lowercqse
SQL
10 votes241 views1 answer
Oracle view dependencies
SQL
0 vote333 views1 answer
Alternative for LIMIT sql
SQL
0 vote280 views1 answer
Insert thai language sql server
SQL
0 vote278 views1 answer
Sql get month and year from date
SQL
5 votes273 views4 answers
Sql check
SQL
2 votes325 views2 answers
Create temporary table in mysql
SQL