Pular para o conteúdo

› Fóruns › Banco de dados Oracle › Criar uma schedule para rodar um script shell › Criar uma schedule para rodar um script shell

18 de novembro de 2011 às 5:25 pm #101693
MarceloPit
Participante

    BEGIN
    DBMS_SCHEDULER.CREATE_JOB (
    job_name => ‘ZZ_TESTE’,
    job_type => ‘EXECUTABLE’,
    job_action => ‘/bdoracle/U04/carga/carga.sh’,
    start_date => sysdate,
    repeat_interval => ‘FREQ=DAILY; INTERVAL=1’,
    enabled => TRUE,
    comments => ‘Testando o CREATE JOB’);
    END;

    ORA-27369: job of type EXECUTABLE failed with exit code: No such process
    STANDARD_ERROR=”Message 2100 not found; No message file for product=RDBMS, facility=ULMessage 2100 not found; No message file for product=RDBMS, facility=UL”