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>
begin
dbms_scheduler.create_job (
auto_drop => true
);
commit;
end;
/
::DELETE OLD LOG FILE
DEL wip_inventory_dbp.log
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