question

pits avatar image
pits asked

maintenance job failure

Good Day, Weekly maintenance jobs for user db is failing,the job involved following tasks, Check DB Integrity task then reorg index task then update statistics task. We checked application logs/history but unable to see any error message which can describe the job failure.The logs just says job is failed. can you please advise what could be possible reason. rgds
jobfailure
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Leo avatar image
Leo answered
If you are using SQL 2005 or 2008 (not sure about 2000) then you can look at in Job Activity History and and expend the **+** sign and look at where the job is exactly failed. Let say ... Check DB is Step 1 and first step is in **RED Cross** then it means that step 1 is failed while checking the DB Integirty. Same thing applied for Step 2 or 3. If DB integrity is failed... you might better run DBCC CHECKDB ('dbname') and see the return message ..it might give you error in DB or something. But you can normally see that in Log or in Job History. Have a look and let us know what you got.
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

On SQL2000 you have to click a checkbox to "Show step details"...
0 Likes 0 ·
Grant Fritchey avatar image
Grant Fritchey answered
Without some kind of error, no, it's just not possible to tell you what's wrong. If you're getting no information out, I'd suggest editing the job in Agent. On the Advanced window of a step for a job inside Agent you can define an output file. I'd place that somewhere and then check that after the next failure. You should have a lot more information to go on.
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

You'll need to check that the SQLAgent account has access to that file/directory...
0 Likes 0 ·
thanks my friends,I could figureout that there was no userdatabases present...thank you for your support again.
0 Likes 0 ·
Tim avatar image
Tim answered
You could also run the steps manually. If the job is failing it could be that CHECK DB is failing and you have corruption. Have these job ever worked? Basically do what @Leo suggested.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.