ADSM-L

Re: Delete running schedule

2002-10-10 10:31:56
Subject: Re: Delete running schedule
From: Bill Boyer <bill.boyer AT VERIZON DOT NET>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 10 Oct 2002 10:31:09 -0400
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:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
Rupp Thomas (Illwerke)
Sent: Thursday, October 10, 2002 9:58 AM
To: ADSM-L AT VM.MARIST DOT EDU
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:   thomas.rupp AT illwerke DOT at
Tel:    +43/5574/601-2583





----------------------------------------------------------------------------
--------------
Dieses eMail wurde auf Viren geprueft.

Vorarlberger Illwerke AG
----------------------------------------------------------------------------
--------------

<Prev in Thread] Current Thread [Next in Thread>