Oracle asynchronous procedure

-- 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 vote372 views1 answer
Hibernate dialect property xml for mysql 8
SQL
0 vote343 views1 answer
Str_to_date sql server
SQL
2 votes332 views1 answer
Sql skip the first row
SQL
5 votes325 views1 answer
Oracle find foreign key dependencies
SQL
3 votes367 views1 answer
Query less than datetime sql
SQL
0 vote356 views1 answer
MySQL INSERT IGNORE Statement
SQL
18 votes315 views4 answers
Foreign key mySql
SQL
0 vote332 views1 answer
Client does not support authentication protocol requested by server sqlyog
SQL
0 vote314 views1 answer
Time in sql server
SQL
2 votes335 views1 answer
Set boolean flasksql
SQL