/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 vote260 views1 answer
Mysql multiple count
SQL
1 vote248 views1 answer
Found option without preceding group in config file: /etc/mysql/mariadb.conf.d/50-server.cnf at line: 1
SQL
0 vote249 views1 answer
Oracle activate program
SQL
0 vote250 views2 answers
SQL Server log file truncate - Source :NAYCode.com
SQL
0 vote273 views1 answer
Oracle sql how to overcome 999 limit for IN
SQL
1 vote197 views1 answer
File /etc/init.d/mysql not exists
SQL
1 vote266 views3 answers
Connect to mysql c# connection string C#
SQL
0 vote254 views1 answer
View to table
SQL
0 vote298 views1 answer
Mariadb.service failed with result 'exit-code'
SQL
0 vote251 views1 answer
Sql auto_increment syntax
SQL