• 0

SQL Maintenance Job Issue


Question

Stokkolm

Hey all, I'm experiencing a strange issue with my SQL Maintenance Cleanup Task. I have it configured to delete old backup files with a "bak" extension that is older than 2 days. When I view the TSQL on the job it looks like this: 

EXECUTE master.dbo.xp_delete_file 0,N'B:\Backups',N'bak',N'2017-01-21T08:36:57',1

However, when I look at the job history and check the TSQL that ran, it's missing the "bak" extension. 

EXECUTE master.dbo.xp_delete_file 0,N''B:\Backups'',N'''',N''2017-01-21T07:49:43'',1
GO

Anyone know why that would be?

 

I have a similar job for transaction logs that is configured the same, except to delete "trn" files and that one executes flawlessly, which has added to my mystification on this. Thanks for any help.
 

Link to post
Share on other sites

1 answer to this question

Recommended Posts

  • 0
Stokkolm

Figured it out....forgot to click Save after modifying the plan >.<

  • Like 1
Link to post
Share on other sites
This topic is now closed to further replies.
  • Recently Browsing   0 members

    No registered users viewing this page.