• Sign in to Neowin Faster!

    Create an account on Neowin to contribute and support the site.

  • 0
Sign in to follow this  

SQL Maintenance Job Issue

Question

Stokkolm    336

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.
 

Share this post


Link to post
Share on other sites

1 answer to this question

Recommended Posts

  • 0
Stokkolm    336

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

  • Like 1

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

  • Recently Browsing   0 members

    No registered users viewing this page.