Tuesday, March 20, 2012

SAve SQLMaint jobs to a central server

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 does
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 server, 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 does
> 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 Gadea

No comments:

Post a Comment