I am trying to retrieve the files attributes like CREATED DATE and wanted to delete files which has datediff as 10 days.
and I got to add this as ManagementJob in SQL 2005.
I activated xp_cmdshell to run the commands.
1. How can i get the file attributes in T-SQL
2. I got to delete the files who have datediff > 10
Please post if anyone knows...
Thanks and Regards,
Manoj.