/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 vote354 views2 answers
Generate sql trigger through ef migration
SQL
0 vote333 views1 answer
Select row with latest date mysql
SQL
11 votes344 views3 answers
Sql line numbers
SQL
1 vote384 views1 answer
Sql select sum group by id laravel
SQL
0 vote386 views1 answer
Sql datum formatieren
SQL
3 votes394 views1 answer
Mysql cli connect with password
SQL
0 vote384 views1 answer
Mariadb change column type
SQL
0 vote321 views1 answer
Azure sql server check foreign key
SQL
0 vote351 views1 answer
Check if string is a number sql
SQL
0 vote352 views1 answer
What are the advantages of MySQL when compared with Oracle?
SQL