Re: SPOOL INTO A JOB

From: CenturionX <darwinbaldrich_at_gmail.com>
Date: Thu, 11 Sep 2008 13:55:53 -0700 (PDT)
Message-ID: <b9ec099a-926f-44a7-be0a-ec65bed16a42@z72g2000hsb.googlegroups.com>

Hello Sybrand,

Thanks for respond.
I'll change the question.

I'm working with Oracle 10.2.0.4.0 on Windows.

I created a job to execute a .bat file

JOB:

---

begin
  dbms_scheduler.create_job (

    job_name     =>'DEL_ALERT_LOG',
    job_type     =>'executable',
    job_action   =>'c:\windows\system32\cmd.exe /c  H:\Reports\Programs


\wip_inventory_dbp.bat > nul',

    enabled      => true,

    auto_drop => true
);
commit;
end;
/

.BAT file

---

::DELETE OLD LOG FILE
DEL wip_inventory_dbp.log

::GENERATE REPORT
ECHO. >> wip_inventory_dbp.log
ECHO Generating report... >> wip_inventory_dbp.log ECHO. >> wip_inventory_dbp.log
sqlplus cms/cms_at_LEGACY_JACKSONVILLE_DEV @H:\Reports\Programs
\wip_inventory.sql

The only thing that executes right is the sqlplus command, The rest: del, echo, doesn't work (just DOS commands does nothing). How can i fix it.
I need a log file to follow the process and i need to add more dos commands in the script.

Thanks for your help. Received on Thu Sep 11 2008 - 15:55:53 CDT