delete old files

hi,
I need to set up a sql job that deletes old files (Old than 2 days) in a
dir.
How do i do that?
Thanksmecn wrote:
> hi,
> I need to set up a sql job that deletes old files (Old than 2 days) in a
> dir.
> How do i do that?
> Thanks
>
One method, using xp_cmdshell:
http://mckibbensupnorth.com/bin/view/RealSQLGuy/CleanupoldFiles
Other options would be an ActiveX script, or CLR in SQL 2005.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Thanks a lot
"Tracy McKibben" <tracy@.realsqlguy.com> wrote in message
news:45A502C5.3020402@.realsqlguy.com...
> mecn wrote:
>> hi,
>> I need to set up a sql job that deletes old files (Old than 2 days) in a
>> dir.
>> How do i do that?
>> Thanks
> One method, using xp_cmdshell:
> http://mckibbensupnorth.com/bin/view/RealSQLGuy/CleanupoldFiles
> Other options would be an ActiveX script, or CLR in SQL 2005.
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com|||Hi,
have a look here:
http://groups.google.de/group/microsoft.public.sqlserver.server/browse_frm/thread/d291e9d8047b7c56/3ff5bdba42e8bb5b
HTH, Jens K. Suessmeyer.
--
http://www.sqlserver2005.de
--
delete files older than days directory certain tsql sql