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?
Thanks
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
|||Thanks a lot
"Tracy McKibben" <tracy@.realsqlguy.com> wrote in message
news:45A502C5.3020402@.realsqlguy.com...
> mecn wrote:
> 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