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

    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
    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 "sqlblindman"

Posting Permissions

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