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 vote191 views1 answer
Get employees if not contains in sql
SQL
11 votes202 views4 answers
Update row in mysql
SQL
13 votes204 views2 answers
Sql join 3 tables
SQL
8 votes185 views2 answers
Mysql query dates between two dates
SQL
0 vote175 views1 answer
SQL division of an integer by another integer get float CAST
SQL
13 votes183 views2 answers
Mysql order by multiple columns
SQL
0 vote303 views1 answer
Python get backup of sql
SQL
0 vote196 views1 answer
Oracle sql date summer time
SQL
1 vote263 views2 answers
Intersect sql
SQL
2 votes194 views1 answer
How to Add a Default Value to a Column in MS SQL Server
SQL