Maintenance Plans Run from SQL Server Agent

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Maintenance Plans Run from SQL Server Agent

Author

Topic

pdset
Constraint Violating Yak Guru

310 Posts

Posted - 2009-12-01 : 16:50:51

I ran the Maintenance plan for OPTIMISATIONS on the Databases, which was driven through Maintenance Plan and run from the Agent Services and this is the error, But the same pattern on other servers there is no problem.

This is the complete error can anyone help me in this regard as to how to negotiate this error.

Date 2/12/2009 7:15:11 AM
Log Job History (uco_Optimisations.Subplan)

Step ID 1
Server DC-DINAR-INFORM01\UCO
Job Name UCO_Optimisations.Subplan
Step Name Subplan
Duration 00:26:37
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0

Message
Executed as user: DC-DINAR-INFORM01\SYSTEM. ....3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 7:15:11 AM Progress: 2009-12-02 07:15:57.10 Source: {4FE4DC54-86D1-4B75-89DE-11876E04D034} Executing query "DECLARE @Guid UNIQUEIDENTIFIER EXECUTE msdb..sp".: 100% complete End Progress Progress: 2009-12-02 07:15:57.77 Source: Check Database Integrity Executing query "USE [AdventureWorks] ".: 100% complete End Progress Progress: 2009-12-02 07:15:59.27 Source: Check Database Integrity Executing query "DBCC CHECKDB WITH NO_INFOMSGS ".: 100% complete End Progress Progress: 2009-12-02 07:15:59.29 Source: Check Database Integrity Executing query "USE [AdventureWorksDW] ".: 100% complete End Progress Progress: 2009-12-02 07:16:00.29 Source: Check Database Integrity Executing query "DBCC CHECKDB WITH NO_INFOMSGS ".: 100% complete End Progress Progress: 2009-12-02 ... The package execution fa... The step failed.

pdset
Constraint Violating Yak Guru

310 Posts

Posted - 2009-12-02 : 18:47:44

Can Anyone please guide me as I dont have any other clues to do.

Thanks

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-12-02 : 18:54:41

This is exactly why I don't use any maintenance plans. The errors can be cryptic, plus the maintenance plans aren't customizable enough.

Here's what I use instead of the optimizations one: http://weblogs.sqlteam.com/tarad/archive/2009/11/03/DefragmentingRebuilding-Indexes-in-SQL-Server-2005-and-2008Again.aspx

Here's all of my custom code which replaces the maintenance plans: http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources