perhaps cancelling the process then updating the schedule to 'inactive'
beforehand might allow you to delete it.

just a stab in the dark.

Matthew Large
TSM Infrastructure Engineer
Lavington Street
Int: 7430 4995
Ext: +44 207 902 4995


-----Original Message-----
From: Rupp Thomas (Illwerke) [mailto:thomas.rupp AT ILLWERKE DOT AT]
Sent: 10 October 2002 14:58
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
----------------------------------------------------------------------------
--------------


-----------------------------------------------------------------------------------------------------------------------
This e-mail is intended only for the above addressee.  It may contain
privileged information. If you are not the addressee you must not copy,
distribute, disclose or use any of the information in it.  If you have
received it in error please delete it and immediately notify the sender.

evolvebank.com is a division of Lloyds TSB Bank plc.
Lloyds TSB Bank plc, 71 Lombard Street, London EC3P 3BS.  Registered in
England, number 2065.  Telephone No: 020 7626 1500
Lloyds TSB Scotland plc, Henry Duncan House, 120 George Street,
Edinburgh EH2 4LH.  Registered in Scotland, number 95237.  Telephone
No: 0131 225 4555

Lloyds TSB Bank plc and Lloyds TSB Scotland plc are regulated by the
Financial Services Authority and represent only the Scottish Widows
and Lloyds TSB Marketing Group for life assurance, pensions and
investment business.

Signatories to the Banking Codes.
-----------------------------------------------------------------------------------------------------------------------