/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 vote376 views1 answer
Check if mysql db is used
SQL
0 vote331 views1 answer
Learn sqlite dart
SQL
0 vote341 views1 answer
Mysql sum with group by
SQL
0 vote282 views1 answer
Microsoft sql server management studio clear cache
SQL
0 vote355 views1 answer
Sql common columns
SQL
0 vote337 views2 answers
Sql join on comma separated field
SQL
3 votes313 views1 answer
Sql several or
SQL
1 vote312 views2 answers
Mysql SELECT
SQL
1 vote343 views2 answers
Sql left characters
SQL
0 vote287 views1 answer
Mysql insert with foreign key
SQL