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

24 votes125 views6 answers
Rename a column in sql server
SQL
1 vote180 views4 answers
Alter schema sql
SQL
23 votes128 views6 answers
Delete all rows from table sql
SQL
7 votes135 views3 answers
Sql fill table with info from anothe rtable
SQL
0 vote127 views1 answer
MySQLdb._exceptions.ProgrammingError: (1146, "Table 'edxapp.app_feedback feedback category' doesn't exist")
SQL
0 vote151 views1 answer
Postgresql show owner of database
SQL
0 vote151 views1 answer
Space not removing from column in sql
SQL
0 vote143 views2 answers
Create-toys-table-with-toy_name-column
SQL
0 vote152 views3 answers
Join
SQL
0 vote130 views1 answer
Drop constraint in ms sql
SQL