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

Question

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

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

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

Brandie Tarvin SSC Guru Points: 173108 More actions · Answer 1

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.

padhis SSCommitted Points: 1762 More actions · Answer 2

Scheduling SQl Agent Job.

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

spaghettidba SSC Guru Points: 105732 More actions · Answer 3

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

-- Gianluca Sartori