LearnItFirst User Forum

New SQL Server 2008 DBA Course
Welcome Guest Search | New Posts | Members | Log In | Register

How can use sql server as scheduler? Options
ravurugopinath@gmail.com
Posted: Tuesday, March 31, 2009 9:27:01 AM
Rank: Newbie

Joined: 3/28/2009
Posts: 3
Points: -91
Where do you live?: bangalore,India

Hi ,

I have doubt about sql server as scheduler.

For example every day at particular query has to be executed.

In details

i have a table called tableA where i am inserting name,phone ,mobile and addeddate

and i have one more table called tableB where i want to insert a record from tableA when addeddate<todaydate .

So will run that scheduler at around 12am in midnight so that i can move records from tableA to tableB .

Is it possible ?

If yes can have any example please . I am struggling for this from many days.

Please help me..
Scott Whigham
Posted: Wednesday, April 15, 2009 10:41:22 AM


Rank: Super Mod

Joined: 3/20/2006
Posts: 460
Points: 1,002
Where do you live?: Dallas, TX
You need to familiarize yourself with the SQL Server Agent - it is the "scheduler" for SQL Server. Check out these videos: http://www.learnsqlserver.com/VideoTutorials/Sql-Server-Videos/100/12-Automating-SQL-Server-SQL-Server-Agent-Jobs-Email.aspx
Users browsing this topic
Guest


Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.