LearnItFirst User Forum

Welcome Guest

Search | New Posts | Members | Log In | Register

SQL Server Forum - LearnItFirst.com » SQL Server Database Administration » Integration Services (SSIS) and DTS » How can use sql server as scheduler?

How can use sql server as scheduler?

Options

Previous Topic · Next Topic

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.