I have job setup on all the PROD servers(2005, 2008r2, 2012).
The Job will generate a .txt file every day for each database to scripts out permission.
And saving a permission scripts for 5day and do clean up.
Here is the issue,
I am doing maintenance cleanup task(maintenance plan) to do a cleanup,
But it is not working, It does not clean up the .txt file on any of the servers (2005, 2008r2, 2012).
what was the issue? Do I am doing wrong way to do cleanup?
any alternate solution do do clean up?
example my file name conversation are: DBname_DBuserlist_20121009