how to delete data from sql server database after expired date

shree · 09-11-2005, 08: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, 10: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, 05: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