how to delete data from sql server database after expired date

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.

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

thank you mr.Roelf
now iam able to do so many experiments.

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


shree