Well you don't even need UNC to do that right?
If you are running the command from the same TDP server then you only
need:
C:\progra~1\tivoli\tsm\tdpsql\sqlfull.cmd
For the command to execute!
Good luck on solving this one though!
Edwin Hernandez
-----Original Message-----
From: Mark Bertrand [mailto:Mark.Bertrand AT USUNWIRED DOT COM]
Sent: Thursday, November 21, 2002 9:28 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: scheduler fails on tdp command scripts (still drives me
nuts )
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:koen_willems AT HOTMAIL DOT COM]
Sent: Thursday, November 21, 2002 7:52 AM
To: ADSM-L AT VM.MARIST DOT EDU
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 <manuel.schweiger AT CHELLO DOT AT>
>Reply-To: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
>To: ADSM-L AT VM.MARIST DOT EDU
>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" <koen_willems AT HOTMAIL DOT COM>
>To: <ADSM-L AT VM.MARIST DOT EDU>
>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 <hoobler AT US.IBM DOT COM>
> > >Reply-To: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
> > >To: ADSM-L AT VM.MARIST DOT EDU
> > >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
> > >hoobler AT us.ibm DOT com
> > >
> > >- 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
|