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 vote127 views1 answer
Alter session set nls_language french
SQL
17 votes180 views3 answers
Postgresql version command
SQL
8 votes186 views1 answer
Mysql restore database
SQL
0 vote166 views1 answer
Oracle remove line breaks
SQL
1 vote163 views1 answer
Window function mysql
SQL
18 votes163 views6 answers
Creating table in MySQL
SQL
1 vote174 views1 answer
Search for tables with name postgresql
SQL
0 vote221 views9 answers
Linq to sql converter online
SQL
0 vote184 views1 answer
Sql get year from datetime field
SQL
0 vote167 views1 answer
Mysql get longest string in column
SQL