The example I supplied does not delete the schedule, nor does it leave temporary schedules around. It just updates itself to run again if the condition is met. If not, then it runs and updates itself to start at the normal time. No temporary schedules....no deleting youself.....
So to change your script to fit in my example... select * from processes if (RC_OK) goto Reschedule if (RC_NOTFOUND)goto Runnow exit /**/ Reschedule: /* Something is running. Schedule myself to start in an hour */ upd sched r_reclaim_on_$1 t=a startt=+01:00 exit /**/ Runnow: /* Nothing is running. Reset myself to the original time for next week */ /* and reset the reclamation threshold for the storage pool. */ upd sched r_reclaim_on_$1 t=a startt=<your start time> upd stg $1 reclaim=$2 exit -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of Rupp Thomas (Illwerke) Sent: Thursday, October 10, 2002 11:04 AM To: [EMAIL PROTECTED] Subject: AW: Delete running schedule Thanks for your response. I want to do Recalamation every Saturday. Therefore I defined a Schedule tos tart the Script ILL_START_RECLAIM. If this Script detects running processes it defines a new (temporary) Schedule to run itself again in 1 hour. If after 1 hour all processes have finished Reclamation is started and the temporary Schedule should be deleted. This deletion raises the error message. Why I want to delete the Schedule? Because I want no temporary Schedules lurking around for a week or longer. Thomas Rupp Vorarlberger Illwerke AG Mail: [EMAIL PROTECTED] Tel: +43/5574/601-2583 -----Urspr|ngliche Nachricht----- Von: Bill Boyer [mailto:[EMAIL PROTECTED]] Gesendet: Donnerstag, 10. Oktober 2002 16:31 An: [EMAIL PROTECTED] Betreff: Re: Delete running schedule Why delete yourself? Just UPDATE youself. Here's a script a co-worker put together to make sure that no backupset processes are running before starting the expire inventory task: select process_num from processes where process like '%BACKUPSET%' if (RC_OK) goto Reschedule if (RC_NOTFOUND)goto Expirenow exit /**/ Reschedule: upd sched expire_inventory t=a startt=+00:20 exit /**/ Expirenow: upd sched expire_inventory t=a startt=15:00 startd=+1 expire inventory duration=510 exit Bill Boyer DSS, Inc. -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of Rupp Thomas (Illwerke) Sent: Thursday, October 10, 2002 9:58 AM To: [EMAIL PROTECTED] Subject: Delete running schedule Hi *SM-ers, the following script starts Reclamation when there a no processes running. If there is a process active it is rescheduled after 60 minutes. select * from processes if (rc_ok) goto reschedule UPDATE STGPOOL $1 RECLAIM=$2 DELETE SCHEDULE R_RECLAIM_ON_$1 TYPE=A <== exit reschedule: del sch r_reclaim_on_$1 type=a def sch r_reclaim_on_$1 t=a cmd="run - Ill_Start_Reclaim $1 $2" - active=yes startt=NOW+0:60 peru=o Line 4 (marked with <==) returns error ANR2706E CSCMDSCH(1157) Scheduler database query failed: 2. because it tries to delete a running schedule (itself). Is there a supported way to delete a running schedule? Kind regards and greetings from Austria Thomas Rupp Vorarlberger Illwerke AG Mail: [EMAIL PROTECTED] Tel: +43/5574/601-2583 ---------------------------------------------------------------------------- -------------- Dieses eMail wurde auf Viren geprueft. Vorarlberger Illwerke AG ---------------------------------------------------------------------------- -------------- ---------------------------------------------------------------------------- -------------- Dieses eMail wurde auf Viren geprueft. Vorarlberger Illwerke AG ---------------------------------------------------------------------------- --------------
