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
