Sql server Agent Jobs

Question

Hi All,

I am using sql server 2008 for creating a job in sql server Agent. can any body help me what i need to do to schedule a job to read a table "xx123" which is another system i.e is also using sqlserver database and insert those records in my database table.

Answer 1

First write a query that will get the data you want. Something like:

Insert into <yourtable>
Select <fieldlist>
From database.dbo.xx123
where <your conditions>

Then create a new job, change the database to be where the table you have created exists and paste this in the textbox.

Then add a schedule (its one of the other tabs on the create job screen).

Sql server Agent Jobs

Follow this question

Related questions