February 2, 2004 at 11:21 am
I used the maintainence planner wizard to build my backup jobs, daily differentials, weekly fulls, integrity checks etc.
The jobs are not succeeding. No backs are being created and all I get for a message is "Last step to run was Step 1"
Does this mean that step 1 was the last job to succeed? Or that step one was the step that rthrew the error?
How do you debug SQL jobs?
Dave
Dave
Trainmark.com IT Training B2B Marketplace
(Jobs for IT Instructors)
February 2, 2004 at 11:24 am
As usual an idea hit me just as I posted. I ran the step from QA and i get this error:
EXECUTE master.dbo.xp_sqlmaint N'-PlanID 75BB91A2-3F0A-42BB-B22E-33ECDAEAB88E -Rpt "E:\_sqlData\MSSQL\LOG\Full maintanence plan6.txt" -DelTxtRpt 4WEEKS -WriteHistory -VrfyBackup -BkUpMedia DISK -BkUpLog -UseDefDir -CrBkSubDir -BkExt ""'
(34 row(s) affected)
Server: Msg 22029, Level 16, State 1, Line 0
sqlmaint.exe failed.
This server only has MSDE so maybe sqlmaint.exe is just not available? I'll look into permissions.
Dave
Trainmark.com IT Training B2B Marketplace
(Jobs for IT Instructors)
February 2, 2004 at 11:41 am
Any errors in errorlog?
Go to maintenance plan --> properties --> reporting tab --> enable "write report to a text file directory" and run the job again, go back to review the report to see any useful inforamtion to help you to debug your problem.
February 3, 2004 at 5:05 pm
Yes thank you I did go check the logs now. The error is in accessing the directory I specified. At first I thought it might be a permission problem but then I noticed that the maintainence plan wizard was coughing up ugly error messages when I tried applying changes. (real ugly) Somehow the wizard is managled.
I will be upgrading that server from MSDE to a full SQL version soon, so in the meantime I'll just back up manually every day.
I expect that will get rid of the problem
Thanks for your help.
Dave
Trainmark.com IT Training B2B Marketplace
(Jobs for IT Instructors)
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply