Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 3 of 3
  1. #1
    New Coder
    Join Date
    Sep 2005
    Posts
    15
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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.

  • #2
    Senior Coder
    Join Date
    Jun 2002
    Location
    Zwolle, The Netherlands
    Posts
    1,120
    Thanks
    2
    Thanked 31 Times in 31 Posts
    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
    I am the luckiest man in the world

  • #3
    New Coder
    Join Date
    Sep 2005
    Posts
    15
    Thanks
    0
    Thanked 0 Times in 0 Posts

    deleting from data from sql server

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

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


    shree


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •