Schedule a job to update a table from another table

[rlatham]

Hello friends,

I am trying to learn how to schedule a job, but I also have this project that seems to be perfect to use this tool.

I would like to schedule a job that would:

1) Run a DTS package I have created (which updates Table2 by droping the rows and replacing them with the content of a txt file)

2) Update Table1 with Table2 by updating matching Table1.IdNumber with Table2.IdNumber, and inserting rows with new Table2.IdNumber

Could anyone help me, please?

Thanks in advance.

 

[mayaugust]

When you created the DTS package, at the final step there will be an option which says Run Immediately (which is selected by default). In the same page there are a couple of other options which gives you the flexibility to schedule the DTS to run at any desired time.