问从Oracle运行.bat脚本

EN

    BEGIN
    SYS.DBMS_SCHEDULER.CREATE_JOB( job_name => 'e_job',
        job_type => 'EXECUTABLE',
        job_action => 'C:\WINDOWS\system32\cmd.exe',
        job_class => 'DEFAULT_JOB_CLASS',
        comments => 'Job to call batch script on Windows',
        auto_drop => FALSE,
        number_of_arguments => 3,
        enabled => FALSE);

    SYS.DBMS_SCHEDULER.SET_JOB_ARGUMENT_VALUE( job_name => 'e_job', argument_position => 1, argument_value => '/q'); 
    SYS.DBMS_SCHEDULER.SET_JOB_ARGUMENT_VALUE( job_name => 'e_job', argument_position => 2, argument_value => '/c'); 
    SYS.DBMS_SCHEDULER.SET_JOB_ARGUMENT_VALUE( job_name => 'e_job', argument_position => 3, argument_value => '"E:\temp\StartLoad.bat"'); 
    SYS.DBMS_SCHEDULER.ENABLE( 'e_job' ); 


   END;

    BEGIN
    DBMS_SCHEDULER.RUN_JOB('example_job');
    END;