Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2010
    Posts
    153

    Unanswered: updation of data in every 7 days

    Hi guys.

    i have 2 doubts
    1) iam getting data in a table from another table and i want those data to get inserted in every 7 days.




    2) i have created a view on multiple tables and iam getting data in my view from those tables. i want to update / get data in that view in every 7 days .


    Kindly provid eme any of the solution.

    Thank you.

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Set up a job through SQL Server agent that runs once per week.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

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