Hi,

I do it in the foll. way.

DELARCH.SQL
---------------------
[code]
REM *=============================================================================+
REM | Notes: This SQL script is a program called by command script 'delarch.cmd' |
REM | It generates spool file 'delgen.cmd' with DOS DEL command in it to |
REM | delete Archive log files from the local machine's hard disk. |
REM +=============================================================================+
REM |
REM | FILENAME
REM | delarch.sql
REM |
REM | DESCRIPTION
REM | Script used to delete archive log files from local PC. It deletes the files
REM | which have been generated before the last friday's cold backup.
REM |
REM | USAGE
REM | This script is called from delarch.cmd file.
REM +============================================================================+
set term off
set feedback off
set heading off
spool on
spool delgen.cmd
SELECT 'DEL '||NAME FROM V$ARCHIVED_LOG
WHERE
TRUNC(COMPLETION_TIME) >= NEXT_DAY(SYSDATE,'FRIDAY')-14
AND TRUNC(COMPLETION_TIME) <= NEXT_DAY(SYSDATE,'FRIDAY')-7;
spool off
exit

[\code]



DELARCH.CMD
------------------
[code]

REM *=============================================================================+
REM | Notes: This command script is used to call 'delarch.sql' program, which |
REM | generates spool file 'delgen.cmd' with DOS DEL command in it to |
REM | delete Archive log files from local machine's hard disk. |
REM | This command script is scheduled to run on every monday at 5:00 PM.|
REM | It can be scheduled with the 'Scheduled tasks' feature of Windows. |
REM +=============================================================================+
REM |
REM | FILENAME
REM | delarch.cmd
REM |
REM | DESCRIPTION
REM | Script used to call 'delarch.sql' file.
REM |
REM | USAGE
REM | This script is scheduled to run on every monday at 5:00 PM.
REM +============================================================================+
sqlplus system/@ @delarch.sql
call delgen.cmd

[\code]


Then, schedule DELARCH.CMD with AT command of NT.

Pl. comment.

Thanks,