there are 2 batfiles running in daily maintenance plans. one, compressing Backups using GZIP and the other deletes old Backup Files.
the delete.bat uses "forfiles" command and successfully deletes files. recenlt the maintenance plan continued to failed and to investigate i foundout that when there are no files met for the bat files' criteria, it is being recorded as an error and
job faliure in SQL Server.
for example, when there are no files to be deleted, the bat file returns a message like "ERROR NO FILES FOUND UNDER THE GIVEN CRITERIA"
this message is interpreted as an error in the SQL Server JOb which is actually not.
do i have a way of handling this kind of errors?
View Complete Post