eh.shams (9/17/2012)

---

I need a script to copy data from one table(source) to anotehr table (destination),
i want to sheduling this task for every 5 minute , rows which data were copied before don't copy again.

eh.shams (9/17/2012)

---

source table is like this one :

Customer Code|cslAccumulationInvoiceItmId| cslAccumulationInvoiceRef |cslDeliveryNoteRef| cslProductRef |Amount |Rate CurrencyRate| price before PriceInBaseCurrency| Deliver No| Date-Reci
400560 46663 46644 28532 21 21.54 504807 1 10873542.78 10873542.78 17169 1/10/2012 00:00
400560 46659 46644 28488 21 22.86 504807 1 11539888.02 11539888.02 17146 1/10/2012 00:00
400560 36414 36413 19204 47 17.66 519230 1 9169601.8 9169601.8 10956 11/30/2011 00:00
400560 35305 35304 18176 47 24.12 519230 1 12523827.6 12523827.6 10361 11/27/2011 00:00
400560 96490 96488 84639 47 22.26 568000 1 12643680 12643680 27082 8/8/2012 00:00
400560 35312 35304 18465 47 22.7 519230 1 11786521 11786521 10549 11/28/2011 00:00

______________________________________________

on the destination i have same table , with only add status (bit) column.
i want to reade from destination and if the status is false , send a message to customer, every 5 minute for example.

on server i have MSSQL SERVER 2008 SP1,
sql agent is ready to .

What columns/data do you ahve to detect what are new rows?

eh.shams (9/17/2012)

---

would you please be more specific , or let me know with example ?
Thanks

INSERT INTO dest_tbl (Col1,Col2, .....)
SELECT Col1,Col2, FROM sorce_tbl 
WHERE NOT EXISTS (SELECT CustId FROM dest_tbl )

eh.shams (9/17/2012)

---

thanks , how i can create job to do it ,periodicaly ?