January 5, 2010 at 9:42 am
I run as
EXECUTE master.dbo.xp_sqlmaint N'-PlanID 05C26610-E745-4EF0-9788-D7CCB8A02939 -Rpt "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\Model DB Maintenance Plan0.txt" -WriteHistory -RebldIdx 10 '
Fails:
Msg 22029, Level 16, State 1, Line 0
sqlmaint.exe failed.
Anyone knows why?
January 5, 2010 at 9:47 am
You may want to look here: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\Model DB Maintenance Plan0.txt
January 5, 2010 at 9:58 am
I checked this is correct location
January 5, 2010 at 10:07 am
Did you read the contents of the file?
January 5, 2010 at 10:09 am
Model DB Maintenance Plan0, that's how I want to name file
January 5, 2010 at 10:14 am
You said the job failed and asked if we knew why. Based on your original post, no. Read the contents of the file shown, it should tell you why the job failed.
January 5, 2010 at 10:20 am
Date1/5/2010 11:27:32 AM
LogJob History (Optimization job)
Step ID1
ServerMDSVSQL
Job NameOptimization job
Step NameOptimizing databases
Duration00:00:00
Sql Severity16
Sql Message ID22029
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted0
Message
Executed as user: CUSTOMDIRECT\sqlservices. sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed.
January 5, 2010 at 10:26 am
SQL Server 2000 or SQL Server 2005?
January 5, 2010 at 10:33 am
2005
January 5, 2010 at 10:39 am
Check out this:
January 5, 2010 at 11:01 am
Logged on to SQL Server 'MDSVSQL' as 'CUSTOMDIRECT\sqlservices' (trusted)
[Microsoft SQL-DMO] Error 21268: [SQL-DMO]Row or column specified is outside the range of the specified query result set.
this is what I get
January 5, 2010 at 11:09 am
Krasavita (1/5/2010)
Logged on to SQL Server 'MDSVSQL' as 'CUSTOMDIRECT\sqlservices' (trusted)[Microsoft SQL-DMO] Error 21268: [SQL-DMO]Row or column specified is outside the range of the specified query result set.
this is what I get
Is this a new issue - the error message looks like something from SQL 2000.
Was this a maint plan that was migrated from SQL 2000?
For the error message, something that tends to work is to recreate the maint plan.
Here is a similar thread from SSC on the same error.
http://www.sqlservercentral.com/Forums/Topic255556-5-1.aspx
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 5, 2010 at 11:17 am
CirquedeSQLeil (1/5/2010)
Krasavita (1/5/2010)
Logged on to SQL Server 'MDSVSQL' as 'CUSTOMDIRECT\sqlservices' (trusted)[Microsoft SQL-DMO] Error 21268: [SQL-DMO]Row or column specified is outside the range of the specified query result set.
this is what I get
Is this a new issue - the error message looks like something from SQL 2000.
Was this a maint plan that was migrated from SQL 2000?
For the error message, something that tends to work is to recreate the maint plan.
Here is a similar thread from SSC on the same error.
1) that's why I did ask earlier if this was SQL Server 2000 or SQL Server 2005.
2) didn't think of asking if this was a migrated MP from SQL Server 2000.
3) usually works to recreate a MP when they go squirrelly.
January 5, 2010 at 11:32 am
This is new maintance plan and I copied code from 2000,but I am using in 2005
January 5, 2010 at 11:34 am
Krasavita (1/5/2010)
This is new maintance plan and I copied code from 2000,but I am using in 2005
I suggest going back and creating a new maint plan, do not use the code from 2000, and then remove the maintplan that is causing these errors.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 15 posts - 1 through 14 (of 14 total)
You must be logged in to reply to this topic. Login to reply