Same thing going on here

http://www.sqlservercentral.com/Forums/Topic1077467-146-1.aspx

sp_configure 'Allow Updates', 0

RECONFIGURE

did the trick.

http://connect.microsoft.com/SQLServer/feedback/details/126163/maintenace-plan-integrity-checks-fail-with-alter-failed-for-server-xxx

That's what stood out in bright red from the trace

I'm getting an error in the trace

Error 14216 (SQL 2005) Severity 10

Job Target Servers:

Its definitely on 2005.

I will look into the trace

It has not worked yet, new job

NEW COMPONENT OUTPUT

Microsoft(R) Server Maintenance Utility (Unicode) Version 9.0.3042

Report was generated on "servername".

Maintenance Plan: TJUHMaint

Duration: 00:00:00

Status: Warning: One or more tasks failed..

Details:

Check Database Integrity...

Kenneth Fisher-475792 (7/25/2011)

---

The facet is "Server". Also don't forget that when you set your expression to a query it has to return a true\false. The example in my...

I didn't see an instance facet. I tried to just use an executeSQL() to just query the table, but that results in a 'The policy: 'Check Online dbs's' contains...

Bumping an old thread.

I've a test system that I'm attempting to get this working on. I've set up my condition as follows:

Facet:Database

@IsSystemObject = False

AND

@status = Normal

If I...

I'm accessing it through EM on the sql 2k box. I've written some scripts as a work around in the meantime.

nvm, I see that this is supposed to run constantly.

thank you!

Yeah, I didn't use rollback immediate, I'll keep that in mind for next time. Thank you so much.

Thank you all for the replies. Alas, the story continues.

I chose Copy_Only option because the client needed the production database restored to a training server and I didn't want...

Yeah....just going to take a while. The backup files are located on the same drive as the db files...so I'm sure that's not helping

Will mirroring blow up if I kill these processes? Will they automaticlly pick back up?