SQLMAINT failed

I have 2 maint plans (db and trn), but they don't delete db.bak and trn as expected.

Deleting old text reports...    0 file(s) deleted.

End of maintenance plan 'swdatasqltrn' on 5/10/2006 2:02:41 AM
SQLMAINT.EXE Process Exit Code: 1 (Failed)

Deleting old text reports...    1 file(s) deleted.

End of maintenance plan 'swdatasqldb' on 5/11/2006 1:02:14 AM
SQLMAINT.EXE Process Exit Code: 0 (Success)

How do you troubleshoot them?
JohnLucaniaAsked:
Who is Participating?
 
QPRConnect With a Mentor Commented:
What account is running the sqlagent service?
Does that account have the required permissions on the folder you want to delete from?

Look at the servers application logs - any clues?
Go into the properties of the maintenance plan, look under reporting, is there a file path to a report?
If so, look for clues there.
0
 
JohnLucaniaAuthor Commented:
>> What account is running the sqlagent service?
>> Does that account have the required permissions on the folder you want to delete from?

Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server 'DATASQL' as 'NT AUTHORITY\SYSTEM' (trusted) Starting maintenance plan 'swdatasqldb' on 5/11/2006 1:00:01 AM

Do you see any issues with this account?
0
 
QPRCommented:
Does the "system" account have the necessary permissions to delete from that folder?
Is there any logging enabled for the plan
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.