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 vote117 views1 answer
Mssql describe stored procedure sqlcmd
SQL
0 vote130 views2 answers
Mysql dump structure only
SQL
2 votes109 views1 answer
Sql missing records from another table
SQL
38 votes131 views4 answers
Count sql
SQL
2 votes123 views1 answer
Sql ends with string
SQL
1 vote74 views1 answer
Strict in postgres SQL
SQL
0 vote109 views1 answer
Selects all the columns from the sailors table
SQL
2 votes126 views1 answer
Orcale index size
SQL
1 vote123 views1 answer
Oracle previous year
SQL
0 vote129 views1 answer
Column ' ' in field list is ambiguous
SQL