Re: Multi-Server Job

From: Narayana Vyas Kondreddi (answer_me@hotmail.com)
Date: 06/06/02


From: "Narayana Vyas Kondreddi" <answer_me@hotmail.com>
Date: Thu, 6 Jun 2002 22:11:54 +0100


Never tried doing it by scripts, but watch out for sp_add_jobserver or
sp_apply_job_to_targets. See BOL for more info.

--
HTH,
Vyas, MVP (SQL Server)
Check out my SQL Server website @
http://vyaskn.tripod.com/
"Shamim" <Shamim.Abdul@railamerica.com> wrote in message
news:OOHtoZZDCHA.1436@tkmsftngp04...
I tried scripting this job, but not able to identify a place where it stores
all target servers.
Thanks
Shamim
"Shamim" <Shamim.Abdul@railamerica.com> wrote in message
news:#YiVgNWDCHA.2072@tkmsftngp02...
> All servers - SQL SERVER 7.0
>
>
> "Narayana Vyas Kondreddi" <answer_me@hotmail.com> wrote in message
> news:unb61yNDCHA.1224@tkmsftngp02...
> > Btw, is the new target server SQL Server 2000 by any chance?
> > --
> > HTH,
> > Vyas, MVP (SQL Server)
> > Check out my SQL Server website @
> > http://vyaskn.tripod.com/
> >
> >
> >
> >
> > "Narayana Vyas Kondreddi" <answer_me@hotmail.com> wrote in message
> > news:O$6FqvNDCHA.2004@tkmsftngp02...
> > I am looking into this and post more info if/when I have it. In the
> > meantime, try to do this using scripts.
> > --
> > HTH,
> > Vyas, MVP (SQL Server)
> > Check out my SQL Server website @
> > http://vyaskn.tripod.com/
> >
> >
> >
> >
> > "Shamim" <Shamim.Abdul@railamerica.com> wrote in message
> > news:#uNl7fMDCHA.1724@tkmsftngp02...
> > Thanks for ur reply.
> > I defect and enlist the server but again with the same issue, 'NOT ABLE
TO
> > SAVE' while adding the new server in the target server.
> > Please Advice.
> >
> > Thanks
> > Shamim
> >
> >
> >
> >
> > "Narayana Vyas Kondreddi" <answer_me@hotmail.com> wrote in message
> > news:OrtoX6LDCHA.2884@tkmsftngp04...
> > > I saw this problem before, but not sure what exactly causes it or how
to
> > > reproduce it. Try this: Cncel that dialog box, defect that new server
> and
> > > enlist the server again. Now try adding the this new server as one of
> the
> > > target servers for the  job.
> > > --
> > > HTH,
> > > Vyas, MVP (SQL Server)
> > > Check out my SQL Server website @
> > > http://vyaskn.tripod.com/
> > >
> > >
> > >
> > >
> > > "Shamim" <Shamim.Abdul@railamerica.com> wrote in message
> > > news:uBE9zmLDCHA.1224@tkmsftngp02...
> > > NO Error message, not allowing to save. On clicking OK button its not
> > > closing the window .
> > > Tried closing down the window, prompting for Save, Cancel ....Again
> > nothing
> > > happen if click on save, so only option to close the
> > > window is to clcik CANCEL.
> > >
> > > Shamim
> > >
> > >
> > > "Narayana Vyas Kondreddi" <answer_me@hotmail.com> wrote in message
> > > news:ugFPERLDCHA.1984@tkmsftngp02...
> > > > What's the error you are getting in Enterprise Manager?
> > > > --
> > > > HTH,
> > > > Vyas, MVP (SQL Server)
> > > > Check out my SQL Server website @
> > > > http://vyaskn.tripod.com/
> > > >
> > > >
> > > >
> > > > "Shamim" <Shamim.Abdul@railamerica.com> wrote in message
> > > > news:Or7I8LLDCHA.1576@tkmsftngp04...
> > > > > HI All,
> > > > >
> > > > >      SQL SERVER 7.0
> > > > >
> > > > > We have a  Multi-server job running againist various production
> > servers.
> > > > > Recently we added a new production server and when trying to add
> this
> > > > server
> > > > > to the job, its NOT allowing me to save.
> > > > >
> > > > > Any thoughts/Ideas...
> > > > >
> > > > > Thanks
> > > > > Shamim
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> > >
> > >
> >
> >
> >
> >
> >
> >
>
>