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 [EMAIL PROTECTED] -----Original Message----- From: Bill Boyer [mailto:[EMAIL PROTECTED] Sent: Thursday, June 19, 2003 12:14 PM To: [EMAIL PROTECTED] 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.
