I was also trying to put some script on Oracle scheduler and successful too.
But on Oracle 8
I failed. It was successful on Oracle 8i (8 doesn't support execute
immediate). Would appreciate,
if someone can give equivalent code for Oracle 8.
Here is the code for Oracle 8i,
create or replace PROCEDURE SWITCH IS
2 BEGIN
3 execute immediate 'alter system switch logfile ';
4 commit ;
5 END;
6 /
Thanks in Advance,
Rajesh
NOTE: It would be executed with any user having sysdba privilege.
-----Original Message-----
Faroult
Sent: Tuesday, January 29, 2002 11:40 AM
To: Multiple recipients of list ORACLE-L
And if you are running an unavowable OS, you can probably turn your
SQL*Plus script into a jPL/SQL procedure and schedule it using dbms_job.
"Weaver, Walt" wrote:
>
> Cron? At?
>
> -----Original Message-----
> Sent: Monday, January 28, 2002 3:21 PM
> To: Multiple recipients of list ORACLE-L
>
> Hello,
> I need to run some script using Oracle Sqlplus. The script is only
suppose
> to run certain days of week.
> Does anyone have a suggestion how to do that.
>
> Thank you.
> --
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Stephane Faroult
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rajesh Dayal
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
