MS SQL Server Connectivity - Maintenance Plan History

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Maintenance Plan History

corinne

2005-11-24, 11:23 am

Could someone help me with the following?

I have got 2 SQL Servers 2000 SP4: ServerA and ServerB

I have set up a maintenance plan on ServerA for DB1
I have set the Reporting properties of the plan to write the history to the
local server and to ServerB

When I select "View History" on the plan to view the content of the
ServerB.msdb.dbo. sysdbmaintplan_histo
ry table I am not getting any
connection error.

Once I have ran the plan on ServerA I would expect to see the outcomes
written to ServerB.

The table is empty.

There are no errors or messages in the SQL Server Agent log, the SQL Server
log or the event log.

Can anyone give me a clue on what I am missing/doing wrong?

Thank you

Regards

Corinne

Sponsored Links