Specify multiple file extensions in maintenance cleanup task

Question

Specify multiple file extensions in maintenance cleanup task

AVB

SSChampion

Points: 11418
More actions
November 27, 2012 at 7:37 am

#267189

Is it possible to specify more than one file extension in a single Maintenance Cleanup Task or do you have to specify a new task for each file type?
Or can you specify all files with a * ?
TIA

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Jason Selburg SSC-Insane Points: 24641 More actions · Answer 1

Why not just "try it" Set up a task to delete any *.* files and set it to run in 5 minutes, then see if it fails. :w00t:

______________________________________________________________________

Personal Motto: Why push the envelope when you can just open it?

If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

Jason L. Selburg

Dennis Post SSCarpal Tunnel Points: 4473 More actions · Answer 2

A task for each type.

For better, quicker answers on T-SQL questions, read Jeff Moden's suggestions.[/url]

"Million-to-one chances crop up nine times out of ten." ― Terry Pratchett, Mort

Dennis Post SSCarpal Tunnel Points: 4473 More actions · Answer 3

I just tried it. Took about 5 mins. 😛

For better, quicker answers on T-SQL questions, read Jeff Moden's suggestions.[/url]

"Million-to-one chances crop up nine times out of ten." ― Terry Pratchett, Mort

AVB SSChampion Points: 11418 More actions · Answer 4

I did setup a task but the least amount of time is a file that is older than an hour. So I created a file but didn't feel like waiting an hour (or searching for older files). Lol. Read BOL and did a small search on-line too but I couldn't find any mention of it.

I don't think *.* will work since .bak doesn't work. Maybe * but I doubt it. We'll find out though soon.

Dennis Post SSCarpal Tunnel Points: 4473 More actions · Answer 5

You don't have to specify an age and you can execute the job immediately.

For better, quicker answers on T-SQL questions, read Jeff Moden's suggestions.[/url]

"Million-to-one chances crop up nine times out of ten." ― Terry Pratchett, Mort