Post reply

I want update records from table1 to table 2 on Weekly basis

  • January 13, 2012 at 5:36 am

    #249608

    I want update records from table1 to table 2 on Weekly basis

    Please can you help me the above case

    Thanks and Regards,

    Madhu

  • January 13, 2012 at 5:53 am

    #1433169

    You can create a SQL Server job with a Transact SQL job step that runs your update code on a weekly schedule.

    If you want more information, please post more details, such as table creation code, sample data inserts, and what you're trying to update.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • January 13, 2012 at 6:46 am

    #1433196

    Scheduling SQl Agent Job.

    http://msdn.microsoft.com/en-us/library/ms191439.aspx

  • January 13, 2012 at 7:58 am

    #1433263

    I suppose snapshot replication would be overkill... but still an option!

    -- Gianluca Sartori

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply