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 vote303 views2 answers
Sql auto update dupdated_at
SQL
1 vote647 views1 answer
Athena query timestamp greater than
SQL
19 votes293 views5 answers
Mysql between date range
SQL
5 votes287 views2 answers
Oracle list columns schema
SQL
5 votes294 views1 answer
Oracle list functions
SQL
0 vote281 views1 answer
How to find sql server name
SQL
7 votes336 views1 answer
Buy forge mods server hosting
SQL
3 votes242 views1 answer
How to get list of synonyms in oracle
SQL
0 vote312 views1 answer
Cannot pip install mysqlclient
SQL
31 votes279 views1 answer
Postgresql add column with constraint
SQL