Re: How to create folder in disk using pl/sql

From: Lewis C <lewisc_at_excite.com>
Date: Sun, 08 May 2005 00:23:26 GMT
Message-ID: <8umq71did08pfri9b43e28p1bprogqo1m3@4ax.com>

On 7 May 2005 12:28:04 -0700, agonenil_at_gmail.com wrote:

>in 10g it is simple.
>just run this :
>begin
> DBMS_SCHEDULER.CREATE_JOB (
> job_name =>'create_dir_test',
> job_type =>'executable',
> job_action => 'c:\winxp\system32\cmd.exe /c mkdir c:\test\test1',
> enabled =>true,auto_drop => true
>);
>commit;
>end;
>/
>
>on windows you will to start OracleJobSchedulerSID before using it.

Sweet! I haven't had a chance to do more than glance at the docs for the scheduler so far. I really need to dig into that some more.

Thanks,

Lewis

---

Lewis R Cunningham

Author, ItToolBox Blog: An Expert's Guide to Oracle http://blogs.ittoolbox.com/oracle/guide/

Topic Editor, Suite101.com: Oracle Database http://www.suite101.com/welcome.cfm/oracle

Sign up for courses here:
http://www.suite101.com/suiteu/default.cfm/416752

---

Received on Sat May 07 2005 - 19:23:26 CDT