...

View Full Version : how to delete data from sql server database after expired date



shree
09-11-2005, 09:32 AM
hi all,

help me please....

i have developed one job website. companies can post jobs in our site and
they will give last date to apply.

problem is when i want to delete jobs from my database which were expired.

iam using sql server7.0.

help me if you know answer.
thank you.

Roelf
09-13-2005, 11:15 AM
in enterprise manager, you can schedule a job to run in a frequency of your choice, specify the sql to run and you will be done

shree
09-15-2005, 06:44 AM
thank you mr.Roelf
now iam able to do so many experiments.

i saw job sheduling after your reply only.
onceagain thankyou.


shree



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum