/SQL/Sql asynchronous stored procedure call

Sql asynchronous stored procedure call

-- 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

16 votes347 views3 answers
Tsql rename column name
SQL
0 vote337 views1 answer
Codeigniter dbforge add index
SQL
0 vote368 views1 answer
BigQuery Remove Duplicate Keys From Table
SQL
1 vote377 views2 answers
Postgres cast as decimal
SQL
0 vote374 views1 answer
Login failed for user sql server
SQL
2 votes369 views1 answer
Q operator in sql
SQL
0 vote333 views1 answer
SQL isnumeric DB2
SQL
1 vote386 views1 answer
Db.Database.SqlQuery
SQL
0 vote355 views4 answers
What is unique key in sql
SQL
0 vote358 views1 answer
Systems sql
SQL