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 vote111 views1 answer
Resolved [java.sql.SQLException: ORA-29977: Unsupported column type for query registration in guaranteed mode ]
SQL
-1 vote166 views2 answers
Import data from excel to sql server automatically
SQL
1 vote165 views1 answer
Mysql month name extract
SQL
2 votes151 views2 answers
Select multiple tables mysql
SQL
1 vote240 views1 answer
Oracle datafile max size 32gb
SQL
0 vote153 views1 answer
What is delimiter in mysql
SQL
0 vote135 views1 answer
Ms sql unique
SQL
0 vote151 views1 answer
Sql server list user permissions
SQL
0 vote185 views1 answer
Sqlcl format
SQL
0 vote154 views1 answer
How should I pass a table name into a stored proc?
SQL