Tuesday, March 20, 2012

SAve SQLMaint jobs to a central server

When setting up a maintenance plan through the wizard, there is the option t
o
select a remote server to receive the job history. However, this option doe
s
not seem available when using SqlMaint to setup jobs. I have a setup where
8
remote servers are setup with one central MSX server. Unfortunately, I can'
t
figure out how to save the job history to the central MSX server and not to
the local servers. Anyone know how the maintenance plan wizard sets things
up to save job histories remotely?
Thanks,
Alex GadeaI don't think that it is the job history which is written to the remote serv
er, it is only the maint
plan history table(s). I might be wrong, of course...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Alex" <Alex@.discussions.microsoft.com> wrote in message
news:46236FC9-AB41-43D6-AE75-4715B66F6267@.microsoft.com...
> When setting up a maintenance plan through the wizard, there is the option
to
> select a remote server to receive the job history. However, this option d
oes
> not seem available when using SqlMaint to setup jobs. I have a setup wher
e 8
> remote servers are setup with one central MSX server. Unfortunately, I ca
n't
> figure out how to save the job history to the central MSX server and not t
o
> the local servers. Anyone know how the maintenance plan wizard sets thing
s
> up to save job histories remotely?
> Thanks,
> Alex Gadea

No comments:

Post a Comment