MasterRacker
New member
I got a basic maintenance plan to run the way I want on a test server. Trying to implement the same plan on a production server has failed so far. I decided to create a test plan so I could test individual components since I'm not getting what I want from the logs.
My test plan right now is a "Reorganize Index Task" set to do all user databases and compact large objects.
If I execute this plan, it claims to finish successfully almost immediately, however the SQL Server log shows nothing at all and the Windows Application log shows the plan start and nothing else.
By comparison, a "Check Database Integrity Task" shows SQL Log entries showing DBCC CHECKDB runs for each and every database.
Why do I see nothing for this task?
Jeff
[small][purple]It's never too early to begin preparing for [/purple]International Talk Like a Pirate Day
"The software I buy sucks, The software I write sucks. It's time to give up and have a beer..." - Me[/small]
My test plan right now is a "Reorganize Index Task" set to do all user databases and compact large objects.
If I execute this plan, it claims to finish successfully almost immediately, however the SQL Server log shows nothing at all and the Windows Application log shows the plan start and nothing else.
By comparison, a "Check Database Integrity Task" shows SQL Log entries showing DBCC CHECKDB runs for each and every database.
Why do I see nothing for this task?
Jeff
[small][purple]It's never too early to begin preparing for [/purple]International Talk Like a Pirate Day
"The software I buy sucks, The software I write sucks. It's time to give up and have a beer..." - Me[/small]