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.
| Author |
Topic |
|
jpiscit1
Posting Yak Master
130 Posts |
 Posted - 2004-09-02 : 08:43:21
|
| I was asked to look into a problem with an existing SQL 2000 installation. The problem has to do with the DB Maintenance Plan that I did not create..When viewing the history of the job it says:The job failed. The Job was invoked by User xxxx. The last step to run was step 1 (Step 1).The error that is being generated when running the same script EXECUTE master.dbo.xp_sqlmaint N'-PlanID 78A9FF1E-00FA-4115-BCBF-8C7E63651B43 -Rpt "D:\SQL Data\MSSQL$ISIADMIN\LOG\DB Maintenance Plan14.txt" -DelTxtRpt 2WEEKS -WriteHistory -VrfyBackup -BkUpMedia DISK -BkUpDB "D:\SQL Data\MSSQL$ISIADMIN\BACKUP" -DelBkUps 2WEEKS -BkExt "BAK"'in the Query Analyzer is as follows:ODBC: Msg 0, Level 16, State 1Cannot find the function xp_sqlmaint in the library D:\Program Files\Microsoft SQL Server\MSSQL$ISIADMIN\Binn\sqlmaint.exe. Reason: 127(The specified procedure could not be found.).I pulled up the stored Procedure xp_sqlmaint.exe (under Master) and it is indeed pointed to D:\Program Files\Microsoft SQL Server\MSSQL$ISIADMIN\Binn\sqlmaint.exe. I verified that the file does actually exist.. Not sure why i would be getting this error?This is a Windows 2K server, SQL 2K w/ SP3. |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2004-09-02 : 08:48:56
|
| Does the maintenance plan exist still? If so has it been recreated? If so then you'll need to reschedule it as the PlanID will not exist anymore...It could also be that the user that is set to try to execute the plan doesn't have the correct permissions to execute it, check that it is set to sa or administrator in the schedule... |
 |
|
|
jpiscit1
Posting Yak Master
130 Posts |
Posted - 2004-09-02 : 09:55:27
|
| The plan was recreated (deleted the old ones) using a different plan name. It was created with the DB Administrator. I scheduled the various taskes to run at 9:50 - 9:55AM this morning. All failed... |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2004-09-02 : 10:09:22
|
| Ok, so are you running this from QA or from the scheduled jobs under SQL Server Agent?!?!?Oh and in the extended procedures in master, the Path for xp_sqlmaint is actually xpstar.dll...EDIT: this may help you.. http://support.microsoft.com/default.aspx?scid=kb;EN-US;288577 |
|
|
|
jpiscit1
Posting Yak Master
130 Posts |
Posted - 2004-09-02 : 14:04:36
|
| The problem was that the xp_sqlmaint path was pointing to the wrong place. Once redirected to the proper library file (xpstar.dll) this ran fine. I have no idea how it got this way.....Thanks for your help. |
|
|
|
|
|
|
Strange Error - Can't find xp_sqlmaint