Optimizations Error - SQL Server Forums

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)

Optimizations Error

Author

Topic

tbrothers
Yak Posting Veteran

83 Posts

Posted - 2008-09-15 : 14:40:56

This job has been running just fine since I upgraded from SQL 2000 to SQL 20005 the first week of July. This weekend I received the following error. Any ideas?

Date 9/14/2008 3:00:01 AM
Log Job History (Optimizations and Organization.Subplan_1)

Step ID 1
Server VB-GP
Job Name Optimizations and Organization.Subplan_1
Step Name Subplan_1
Duration 03:46:52
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0

Message
Executed as user: TBT\SQLSERVICE. ... End Progress Progress: 2008-09-14 03:17:21.63 Source: Check Database Integrity Executing query "USE [RPT] ".: 50% complete End Progress Progress: 2008-09-14 03:17:23.42 Source: Check Database Integrity Executing query "DBCC CHECKDB WITH NO_INFOMSGS ".: 100% complete End Progress Progress: 2008-09-14 03:17:23.42 Source: Check Database Integrity Executing query "USE [DYNAMICS] ".: 50% complete End Progress Progress: 2008-09-14 03:17:53.34 Source: Check Database Integrity Executing query "DBCC CHECKDB WITH NO_INFOMSGS ".: 100% complete End Progress Progress: 2008-09-14 03:17:53.35 Source: Check Database Integrity Executing query "USE [Fsa_1] ".: 50% complete End Progress Progress: 2008-09-14 03:18:45.04 Source: Check Database Integrity Executing query "DBCC CHECKDB WITH NO_INFOMSGS ".: 100% complete End Progress Progress: 2008-09-14 03:28:20.49 S... The package execution fa... The step failed.

Thanks,
Terry

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-09-15 : 14:43:29

Unfortunately, the error has been caught off since the job history doesn't store much information. Could you check for the actual error in the maintenance plan's log?

Or better yet, avoid maintenance plans altogether! I don't have any in any of my environments. I instead write my own which are prone to less issues: http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx

My scripts are widely used around the world based upon feedback I've received. They are also free to use.

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

Subscribe to my blog

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources