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 vote96 views1 answer
Mysql> grant all privileges on *.* to root@localhost identified by 'password' with grant option;
SQL
3 votes126 views2 answers
Synonym oracle
SQL
1 vote82 views1 answer
Sql convert month name to number
SQL
3 votes101 views3 answers
Into in sql
SQL
1 vote107 views1 answer
PL SQL MODIFY COLUMN NME
SQL
2 votes146 views3 answers
Mysql kill
SQL
0 vote106 views1 answer
Postgresql default value boolean
SQL
1 vote106 views1 answer
Mysql illegal mix of collations for operation 'join'
SQL
6 votes98 views1 answer
Phpmyadmin password root
SQL
0 vote103 views1 answer
Like and not like together in sql
SQL