Hi there! No Nuts... Just the fruits of my labour! This is how I do it on NT... it's a daily restore, but the principle is the same. Note the "exit 0" to set "errorlevel" to 0 and the "Progra~1" (no spaces). The first file calls the second, output is redirected to a logfile with timestamps. Waitfor is an NT resource kit command. "prompt $g" just makes the logfile less clutered. 2 copies of the log are retained. Simple but effective!
Rgds Tony Morgan Fortis Bank SA/NV UK Branch HQ ---------------------------------------------------------------------------- ------------- Objects Field ~~~~~~~~~~~~~ c:\progra~1\tivoli\tsm\baclient\RestoreDB1.cmd RestoreDB1.cmd ~~~~~~~~~~~~~~ @echo on c: cd \progra~1\tivoli\tsm\baclient del RestoreDB.old ren RestoreDB.log RestoreDB.old waitfor -t 2 fileclose RestoreDB2.cmd >>Restoredb.log waitfor -t 2 fileclose exit 0 RestoreDB2.cmd ~~~~~~~~~~~~~~ prompt $g @echo on c: cd \progra~1\tivoli\tsm\baclient @echo Timestamp Log @echo ---------------------------------------------------------------- Date /T Time /T @Echo Start Procedure @echo ---------------------------------------------------------------- dsmc restore \\server1\c$\appx5\Server\admin\*.* \\server2\d$\appx5\Server\ -virtualnodename=server1 -subdir=yes -replace=all -tapeprompt=no -pas=XXX dsmc restore \\server1\c$\appx5\Server\object\*.* \\server2\d$\appx5\Server\ -virtualnodename=server1 -subdir=yes -replace=all -tapeprompt=no -pas=XXX dsmc restore \\server1\c$\appx5\Server\request\*.* \\server2\d$\appx5\Server\ -virtualnodename=server1 -subdir=yes -replace=all -tapeprompt=no -pas=XXX @echo Timestamp Log @echo ---------------------------------------------------------------- Date /T Time /T exit 0 -----Original Message----- From: Koen Willems [mailto:[EMAIL PROTECTED]] Sent: 21 November 2002 15:08 To: [EMAIL PROTECTED] Subject: Re: scheduler fails on tdp command scripts (still drives me nuts ) I wish it was that easy for me, on the object line I stated: '"c:\program files\tivoli\tsm\agentoba\orcschedppim.cmd"' I run the latest level..... Nuts, Koen. >From: Mark Bertrand <[EMAIL PROTECTED]> >Reply-To: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> >To: [EMAIL PROTECTED] >Subject: Re: scheduler fails on tdp command scripts (still drives me nuts ) >Date: Thu, 21 Nov 2002 08:28:04 -0600 > >Koen, > >OK, I'm going to step up and speak out. I had two similar problems not too >long ago, and I'm really embarrassed about the mistakes that were made. > >The first was that when setting up the schedule I mistakenly put the path >and script line in the Options box instead of Objects, yes I'm a GUI user. >Not too ashamed about that one because it was a pretty easy mistake to >find. > >The second one took about a week, the script would run error free from the >client but failed in schedule and exited with > >ANS1512E Scheduled event '2330_YOUR_SCHED_SQL' failed. Return code = 1. > >I knew the problem just had to be permissions or a client issue. I checked >and changed permissions at the client, and within SQL. I upgraded to the >latest TDP for SQL, still RC=1. I searched the archives but ANS1512E and >RC=1 are WAY TOO generic (hint, hint IBM'ers) so I decided not to post or >call it in since there was really no emergency since it would run OK >manually. Just as you stated "drives me nuts". > >So I decided to break it down and go one step at a time, that's when I >spotted on the Objects line, my node name instead of the server name for >the >path. ***I put my head down in shame*** > >\\servername_sql\c$\progra~1\tivoli\tsm\tdpsql\sqlfull.cmd > >All is well now. Not to proud about that one, but hope it may help others. > >Mark B. > > > >-----Original Message----- >From: Koen Willems [mailto:[EMAIL PROTECTED]] >Sent: Thursday, November 21, 2002 7:52 AM >To: [EMAIL PROTECTED] >Subject: Re: scheduler fails on tdp command scripts (still drives me >nuts ) > > >Manuel, > >You are a mind reader huh ;-) > >Using the NT scheduler is my fall back plan.... > >But it isnt as nice as using the TSM scheduler.. > >I am getting a little frustrated, normally the TSM scheduler works fine... > >Still clueless, > >Koen > > > > > > > >From: Manuel Schweiger <[EMAIL PROTECTED]> > >Reply-To: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> > >To: [EMAIL PROTECTED] > >Subject: Re: scheduler fails on tdp command scripts (still drives me >nuts > >) > >Date: Thu, 21 Nov 2002 14:44:06 +0100 > > > >Koen, > > > >Until I changed it to run under admin rights (as mentioned before) I just > >did a workaround in running the script with the windows scheduler. Not a > >perfect solution but until someone can solve your problem on this you >could > >at least work with that. > > > >Regards, Manuel > > > >----- Original Message ----- > >From: "Koen Willems" <[EMAIL PROTECTED]> > >To: <[EMAIL PROTECTED]> > >Sent: Thursday, November 21, 2002 2:35 PM > >Subject: Re: scheduler fails on tdp command scripts (still drives me nuts >) > > > > > > > Dear Del, > > > > > > the command scipt runs.. via DOS. > > > > > > The scheduler does not run the script. > > > > > > I see some brief communcation with the tsm server: > > > > > > My ac logs says: > > > > > > 11/21/2002 14:03:38 ANR0406I Session 1214 started for node > >SERVER03_ORACLE > > > (WinNT) (Tcp/Ip 172.16.1.249(1146)). > > > 11/21/2002 14:03:38 ANR0403I Session 1214 ended for node > >SERVER03_ORACLE > > > (WinNT). > > > > > > The my schedlog say: > > > > > > 11/21/2002 14:25:58 > > > Executing Operating System command or script: > > > "c:\program files\tivoli\tsm\agentoba\orcschedppim.cmd" > > > 11/21/2002 14:25:58 Finished command. Return code is: 3 > > > 11/21/2002 14:25:58 ANS1909E The scheduled command failed. > > > 11/21/2002 14:25:58 ANS1512E Scheduled event 'ORACLE_0130' failed. > >Return > > > code = 3. > > > 11/21/2002 14:25:58 Sending results for scheduled event 'ORACLE_0130'. > > > 11/21/2002 14:25:58 Results sent to server for scheduled event > > > 'ORACLE_0130'. > > > > > > 11/21/2002 14:25:58 Querying server for next scheduled event. > > > 11/21/2002 14:25:58 Node Name: SERVER010_ORACLE > > > 11/21/2002 14:25:58 Session established with server BUS_SERVER1: >Windows > > > 11/21/2002 14:25:58 Server Version 5, Release 1, Level 5.0 > > > 11/21/2002 14:25:58 Server date/time: 11/21/2002 14:25:58 Last > >access: > > > 11/21/2002 14:25:58 > > > > > > 11/21/2002 14:25:58 --- SCHEDULEREC QUERY BEGIN > > > 11/21/2002 14:25:58 --- SCHEDULEREC QUERY END > > > 11/21/2002 14:25:58 Next operation scheduled: > > > 11/21/2002 14:25:58 > > > ------------------------------------------------------------ > > > 11/21/2002 14:25:58 Schedule Name: ORACLE_0130 > > > 11/21/2002 14:25:58 Action: Command > > > 11/21/2002 14:25:58 Objects: "c:\program > > > files\tivoli\tsm\agentoba\orcschedppim.cmd" > > > 11/21/2002 14:25:58 Options: > > > 11/21/2002 14:25:58 Server Window Start: 14:25:00 on 11/22/2002 > > > 11/21/2002 14:25:58 > > > ------------------------------------------------------------ > > > 11/21/2002 14:25:58 Schedule will be refreshed in 6 hours. > > > > > > my errolog says: > > > > > > 11/21/2002 14:25:58 ANS1909E The scheduled command failed. > > > 11/21/2002 14:25:58 ANS1512E Scheduled event 'ORACLE_0130' failed. > >Return > > > code = 3. > > > > > > I did an upgrade sched like this: > > > > > > update schedule oracle_domain oracle_0130 objects='"c:\program > > > files\tivoli\tsm\agentoba\orcschedppim.cmd"' > > > > > > Best Regards, > > > > > > Koen Willems > > > > > > > > > > > > > > > > > > >From: Del Hoobler <[EMAIL PROTECTED]> > > > >Reply-To: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> > > > >To: [EMAIL PROTECTED] > > > >Subject: Re: scheduler fails on tdp command scripts ( drives me nuts >) > > > >Date: Thu, 21 Nov 2002 08:10:05 -0500 > > > > > > > >Koen, > > > > > > > >The first thing you should check is to make sure the > > > >command script is even being run. > > > >A good way to test this is to put a command in > > > >script that generates some type of output on > > > >the local machine that you can check. That way > > > >you can see if the script is even being executed. > > > >For example: DIR C:\TEMP > C:\TEMP\TEST.OUT. > > > >If, after the schedule runs, the "TEST.OUT" file > > > >is not generated, then the script is not even > > > >being run and the problem is probably with the > > > >definition of the schedule. > > > >If that is the case... > > > > > > > >Are you specifying the full path name to the script > > > >in the objects field of the defined schedule? > > > > > > > >Are there spaces in the path name? If there are, > > > >you may have to use double quotes and single quotes > > > >around the parameter when defining the "objects=xxx" option. > > > >For example: > > > > > > > > OBJECTS='"C:\Program Files\Tivoli\TSM\domino\dominc.cmd"' > > > > > > > >Notice the two sets of quotes, a set of single quotes > > > >and a set of double quotes. > > > > > > > >Thanks, > > > > > > > >Del > > > > > > > >---------------------------------------------------- > > > > > > > >Del Hoobler > > > >IBM Corporation > > > >[EMAIL PROTECTED] > > > > > > > >- Never cut what can be untied. > > > >- Commit yourself to constant improvement. > > > > > > > >============================================================== > > > > > > When isntalling a scheduler for my TDP with dsmcutil and >defining > >a > > > > >schedule > > > > > > on the server with action command and object the command script > > > > > > all looks fine. > > > > > > > > > > > > The dsmched.log shows a new time slot and when I check on the > >server > >I > > > > >get > > > > >a > > > > > > succes when entering q ev * *. > > > > > > > > > > > > The thing is that my backup has failed with. error 1 or 4. > > > > > > > > > > > > I already tried different user accounts. But this does not >help... > > > > > > > > > > > > Anybody ???? > > > > > > > > > _________________________________________________________________ > > > The new MSN 8: smart spam protection and 2 months FREE* > > > http://join.msn.com/?page=features/junkmail > > >_________________________________________________________________ >Tired of spam? Get advanced junk mail protection with MSN 8. >http://join.msn.com/?page=features/junkmail _________________________________________________________________ Tired of spam? Get advanced junk mail protection with MSN 8. http://join.msn.com/?page=features/junkmail ============================================================ This e-mail and any files transmitted with it, are confidential and intended solely for the use of the addressee. The content of this e-mail may have been changed without the consent of the originator. The information supplied must be viewed in this context. If you have received this e-mail in error please notify our Helpdesk by telephone on +44 (0) 20-7444-8444. Any use, dissemination, forwarding, printing, or copying of this e-mail or its attachments is strictly prohibited.