From: "Robert Comer" 

> 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