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 vote348 views1 answer
Sql update subtract value
SQL
1 vote337 views3 answers
How to truncate table with foreign key constraint
SQL
7 votes312 views1 answer
Forge server hosting
SQL
0 vote338 views2 answers
Uncaught Error: Cannot use object of type mysqli_result as array
SQL
0 vote336 views2 answers
Soql last year
SQL
0 vote399 views1 answer
Postgres extract number from string
SQL
0 vote303 views1 answer
Get all employees if name ends with in sql
SQL
0 vote308 views1 answer
Is numeric in sql
SQL
0 vote329 views2 answers
Call to undefined function mysqli_fetch_all()
SQL
0 vote370 views1 answer
Python dictionary to sql update
SQL