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

3 votes138 views3 answers
Remove all spaces from string sql
SQL
8 votes94 views2 answers
Alter column name in mssql
SQL
0 vote187 views1 answer
Updating database in sql
SQL
4 votes161 views2 answers
Oracle unlock account
SQL
0 vote148 views2 answers
Sql max count
SQL
2 votes90 views2 answers
Mysql get last character of string
SQL
8 votes140 views1 answer
Oracle current date plus 1 month
SQL
4 votes138 views3 answers
Postgres set default value
SQL
0 vote146 views1 answer
Create table with float datatype in sql server
SQL
1 vote140 views3 answers
Epoch to datetime
SQL