From: "Robert Comer" 

No problem!

Just as an example:

Here's a .BAT file:

isql /d ProdInfo /n /Uxxxxxx /Pxxxxxx >c:\administration\checkident.txt
 OK, then I think maybe I'm in business.   Thanks!    :)
>
> On Mon, 13 Jan 2003 07:12:02 -0500, "Robert Comer"
>  wrote in message :
>
> >> OK, stupid question time, if I make a .BAT file and each line kicks off
> >> an executable, does each next line wait until the previous process
> >> finishes?
> >
> >Yes, it waits. (unless you use START to launch something that is.)
> >
> >- Bob Comer
> >
> >
> >"Ellen K."  wrote in message
> >news:rkm42v0iq0e0b90sbh9f2oj3js445kcp4c{at}4ax.com...
> >> OK, stupid question time, if I make a .BAT file and each line kicks off
> >> an executable, does each next line wait until the previous process
> >> finishes?
> >>
> >> On Mon, 13 Jan 2003 00:03:23 -0500, "Robert Comer"
> >>  wrote in message
:
> >>
> >> >> Well so if it's scheduled events... can you schedule a SET of
events,
> >so
> >> >> each one runs after the previous one completes?
> >> >
> >> >Sure, just make a good old DOS .BAT file. (actually it's a NT cmd
file,
> >but
> >> >close enough.)
> >> >
> >> >>I could put a little
> >> >> app on the backup box that would run my purge and
archive routines,
IF
> >> >> there's a way to tell it to run that AFTER the log
and database
backups
> >> >> complete, and then to run another log backup after that...
> >> >
> >> >You should be able to do that, return codes might be a
problem and you
> >might
> >> >have to do a little coding in VB or something to interpret things.
Most
> >of
> >> >my scheduled events are kind of one sided, just submit
and forget type
> >> >things on the NT side.
> >> >
> >> >- Bob Comer
> >> >
> >> >
> >> >
> >> >"Ellen K." 
wrote in message
> >> >news:j5942v80j9cjndriah112opuij5p46h7al{at}4ax.com...
> >> >> Well so if it's scheduled events... can you schedule a SET of
events,
> >so
> >> >> each one runs after the previous one completes?   I
could put a
little
> >> >> app on the backup box that would run my purge and
archive routines,
IF
> >> >> there's a way to tell it to run that AFTER the log
and database
backups
> >> >> complete, and then to run another log backup after that...
> >> >>
> >> >> On Sun, 12 Jan 2003 17:31:15 -0500, "Robert Comer"
> >> >>  wrote in message
:
> >> >>
> >> >> >> So  I would use this on the Veritas box to
send commands to the
SQL
> >> >> >> Server one?
> >> >> >
> >> >> >Possibly.
> >> >> >
> >> >> >>Does it know when the operation started by the sent
> >> >> >> command finishes?
> >> >> >
> >> >> >Good status messages between them would be a bit
of a problem,
> >probably
> >> >have
> >> >> >to cobble some kind of message passing to get
detailed type stuff.
> >Most
> >> >of
> >> >> >the time I use our AS/400 to send remote
commands to PC's and with
it
> >I
> >> >get
> >> >> >a full stdout from whatever command I run so
it's easy, don't know
> >what
> >> >I'd
> >> >> >do if it were NTS to NTS. Personally I don't use
remote command to
> >back
> >> >up
> >> >> >my SQL server, I just use scheduled events, on
both the backup and
the
> >> >SQL
> >> >> >server PC's, to arrange things so the right
thing gets backed up
when.
> >> >> >
> >> >> >- Bob Comer
> >> >> >
> >> >> >
> >> >> >"Ellen K."
 wrote in message
> >> >> >news:u4p32v454b4tclu2i507v10gimtef1ibj1{at}4ax.com...
> >> >> >> So  I would use this on the Veritas box to
send commands to the
SQL
> >> >> >> Server one?    Does it know when the
operation started by the
sent
> >> >> >> command finishes?
> >> >> >>
> >> >> >> On Sun, 12 Jan 2003 15:26:49 -0500,
"Robert Comer"
> >> >> >>  wrote in message
:
> >> >> >>
> >> >> >> >Remote command.  It's for sending
remote commands to another
> >machine.
> >> >> >> >
> >> >> >> >- Bob Comer
> >> >> >> >
> >> >> >> >
> >> >> >> >"Ellen K."
 wrote in message
> >> >> >>
>news:04d32vs5d5enokpkpe0jobtobj046d1os6{at}4ax.com...
> >> >> >> >> What's rexec?
> >> >> >> >>
> >> >> >> >> On Sun, 12 Jan 2003 08:53:58
-0500, "Robert Comer"
> >> >> >> >> 
wrote in message
> >:
> >> >> >> >>
> >> >> >> >> >> but the commands run on
the local machine and not a remote
> >> >machine.
> >> >> >And
> >> >> >> >> >> Ellen's SQL server is the
remote machine in this scenario I
> >> >guess.
> >> >> >> >> >
> >> >> >> >> >I don't see why it couldn't use rexec...
> >> >> >> >> >
> >> >> >> >> >- Bob Comer
> >> >> >> >> >
> >> >> >> >> >
> >> >> >> >> >"Peter Sawatzki"
 wrote in message
> >> >> >> >>
>news:MPG.188b8fc1b78282c49896da{at}news.barkto.com...
> >> >> >> >> >> In article
,
> >> >> >> >> >> mnice{at}spamcop.net says...
> >> >> >> >> >> > On Sat, 11 Jan 2003
19:13:57 -0800, Ellen K.
> >> >> >> >
> >> >> >> >> >wrote:
> >> >> >> >> >> >
> >> >> >> >> >> > >Neither you nor
George addressed my other question,
which
> >is
> >> >very
> >> >> >> >> >> > >important, i.e.
I want to make the backing up part of a
> >larger
> >> >> >> >> >> >
>"housekeeping" routine, how would that work?
> >> >> >> >> >> >
> >> >> >> >> >> >    The full version
of Veritias Backup Exec has the
option
> >of
> >> >> >> >commands
> >> >> >> >> >to run before and after the
> >> >> >> >> >> > backup job.
> >> >> >> >> >> >
> >> >> >> >> >> >
> >> >> >> >> >>
> >> >> >> >> >> but the commands run on
the local machine and not a remote
> >> >machine.
> >> >> >And
> >> >> >> >> >> Ellen's SQL server is the
remote machine in this scenario I
> >> >guess.
> >> >> >> >> >>
> >> >> >> >> >> PEter
> >> >> >> >> >
> >> >> >> >>
> >> >> >> >
> >> >> >>
> >> >> >
> >> >>
> >> >
> >>
> >
>

--- BBBS/NT v4.01 Flag-4