Hello

I need to runa procedure which deletes all data older than 3 months on
the successful completion of backups in a Datbase Maintenance plan.

Any ideas - please help

Melanie

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Melany
declare @dt datetime
set @dt='20041101'

SELECT <column lists> FROM Table WHERE col >=@dt and col <
dateadd(day,1,getdate())


"Melanie Mayfield" <melanie.mayfield (AT) ultraasp (DOT) net> wrote

Thanks Uri
I need the procedure to be automatically firect on the successful
completion of the back up in the DB Maintenance Plan, I know success of
the DB Maintenance Plan is logged in the sysdbmaintain_history table,
but I need to an automatic process to check this.

Thanks for your help once again!

Melanie

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!