/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

0 vote164 views1 answer
Sql python hwo to pass a list in paramerter
SQL
2 votes229 views2 answers
Mysql compare datetime to another datetime
SQL
1 vote200 views1 answer
Psql client write to bash variable
SQL
2 votes249 views1 answer
Postgresql group by month and year
SQL
1 vote229 views1 answer
Get the User Name and Domain Name from an Email Address
SQL
0 vote143 views1 answer
Sql query to select records entered in last 24 hours
SQL
2 votes311 views5 answers
Unique in sql server
SQL
0 vote159 views1 answer
Excel export from sql using python
SQL
8 votes161 views1 answer
Sql remove leading spaces
SQL
2 votes175 views3 answers
Sql server: how to concatenate column data using comma
SQL