Re: Delete running schedule
2002-10-10 10:31:56
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
----------------------------------------------------------------------------
--------------
|
|
|