/SQL/Pl sql asynchronous procedure calls

Pl sql asynchronous procedure calls

-- 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 vote140 views1 answer
How to find unique element in sql
SQL
1 vote127 views1 answer
Wordpress change url phpmyadmin
SQL
0 vote121 views1 answer
Select count postgres double row count > 1
SQL
1 vote105 views1 answer
How to open closed port mysql in ubuntu
SQL
9 votes125 views3 answers
Where clause sql
SQL
0 vote120 views1 answer
Is there a way to use read_sql_query and the query has WHERE column = Variable?
SQL
0 vote109 views1 answer
Select other columns with distinct
SQL
2 votes110 views1 answer
Check isolation level in mysql
SQL
0 vote114 views1 answer
Backup and restore of sqlite database from c# -sqlserver
SQL
0 vote112 views1 answer
Install mysql for fedora 34
SQL