ADSM-L

Re: Schedule for the last day of the month...every month

2003-06-19 13:27:48
Subject: Re: Schedule for the last day of the month...every month
From: "Ford, Phillip" <phillip.ford AT SPCORP DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 19 Jun 2003 13:27:18 -0400
If you are doing it inside TSM I can give you an approach.  I am not good
with SQL so you or someone on this list could help.  You could run a
schedule everyday and have a select statement in it like the following:

select 1 from whatever where month(current date) = month(current date + 1
day)
if(rc_ok) goto stop
do your stuff for the last day of the month
exit
stop:
do stuff here for other days
exit




Hope that helps



--
Phillip Ford
Senior Software Specialist
Corporate Computer Center
Schering-Plough Corp.
(901) 320-4462
(901) 320-4856 FAX
phillip.ford AT spcorp DOT com





-----Original Message-----
From: Bill Boyer [mailto:bill.boyer AT VERIZON DOT NET]
Sent: Thursday, June 19, 2003 12:14 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Schedule for the last day of the month...every month


I have a client that wants to do monthly backups on the last day of the
month. A co-worker did some testing and creating a schedule for say
5/31/3002 with PERU=MONTH. The June event gets scheduled for 6/30, but then
remains the 30th day from then on. Until Feb next year when it moves to the
29th.

Outside of creating a schedule for each month with a PERU=YEAR, is there a
way to do a schedule on the last day of every month??

TIA,
Bill Boyer
"Some days you are the bug, some days you are the windshield." - ??


*********************************************************************
This message and any attachments are solely for the intended recipient. If you 
are not the intended recipient, disclosure, copying, use or distribution of the 
information included in this message is prohibited -- Please immediately and 
permanently delete.