InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 21:57:08 GMT20http://www.sqlservercentral.com/Forums/Topic1360534-391-1.aspxThank'sTue, 18 Sep 2012 00:05:56 GMTeh.shamshttp://www.sqlservercentral.com/Forums/Topic1360534-391-1.aspx[quote][b]eh.shams (9/17/2012)[/b][hr]thanks , how i can create job to do it ,periodicaly ?[/quote]That could be a very involved question. I suggest you look through the Stairway to SQL Server Agent series: [url]http://www.sqlservercentral.com/stairway/72403/[/url]You'll probably only need to read the first 3-4 articles to do what you need to do.Mon, 17 Sep 2012 23:49:08 GMTdwain.chttp://www.sqlservercentral.com/Forums/Topic1360534-391-1.aspxthanks , how i can create job to do it ,periodicaly ?Mon, 17 Sep 2012 23:10:05 GMTeh.shamshttp://www.sqlservercentral.com/Forums/Topic1360534-391-1.aspx[quote][b]eh.shams (9/17/2012)[/b][hr]would you please be more specific , or let me know with example ?Thanks[/quote]e.g. in Source and Destination table CustID is unique number then we can have below query to insert only new records[code="sql"]INSERT INTO dest_tbl (Col1,Col2, .....)SELECT Col1,Col2, FROM sorce_tbl WHERE NOT EXISTS (SELECT CustId FROM dest_tbl )[/code]Mon, 17 Sep 2012 22:58:00 GMTrhythmkhttp://www.sqlservercentral.com/Forums/Topic1360534-391-1.aspxwould you please be more specific , or let me know with example ?ThanksMon, 17 Sep 2012 22:31:10 GMTeh.shamshttp://www.sqlservercentral.com/Forums/Topic1360534-391-1.aspx[quote][b]eh.shams (9/17/2012)[/b][hr]source table is like this one :Customer Code|cslAccumulationInvoiceItmId| cslAccumulationInvoiceRef |cslDeliveryNoteRef| cslProductRef |Amount |Rate CurrencyRate| price before PriceInBaseCurrency| Deliver No| Date-Reci400560 46663 46644 28532 21 21.54 504807 1 10873542.78 10873542.78 17169 1/10/2012 00:00400560 46659 46644 28488 21 22.86 504807 1 11539888.02 11539888.02 17146 1/10/2012 00:00400560 36414 36413 19204 47 17.66 519230 1 9169601.8 9169601.8 10956 11/30/2011 00:00400560 35305 35304 18176 47 24.12 519230 1 12523827.6 12523827.6 10361 11/27/2011 00:00400560 96490 96488 84639 47 22.26 568000 1 12643680 12643680 27082 8/8/2012 00:00400560 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 .[/quote]As mentioned by Kraig[quote]What columns/data do you ahve to detect what are new rows? [/quote]Based on that you can have UPINSERT script and schedule it as per your need.Mon, 17 Sep 2012 22:16:55 GMTrhythmkhttp://www.sqlservercentral.com/Forums/Topic1360534-391-1.aspxsource table is like this one :Customer Code|cslAccumulationInvoiceItmId| cslAccumulationInvoiceRef |cslDeliveryNoteRef| cslProductRef |Amount |Rate CurrencyRate| price before PriceInBaseCurrency| Deliver No| Date-Reci400560 46663 46644 28532 21 21.54 504807 1 10873542.78 10873542.78 17169 1/10/2012 00:00400560 46659 46644 28488 21 22.86 504807 1 11539888.02 11539888.02 17146 1/10/2012 00:00400560 36414 36413 19204 47 17.66 519230 1 9169601.8 9169601.8 10956 11/30/2011 00:00400560 35305 35304 18176 47 24.12 519230 1 12523827.6 12523827.6 10361 11/27/2011 00:00400560 96490 96488 84639 47 22.26 568000 1 12643680 12643680 27082 8/8/2012 00:00400560 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 .Mon, 17 Sep 2012 21:59:30 GMTeh.shamshttp://www.sqlservercentral.com/Forums/Topic1360534-391-1.aspx[quote][b]eh.shams (9/17/2012)[/b][hr]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.[/quote]What columns/data do you ahve to detect what are new rows? What's the table look like? what tools do you have available? SQLAgent, SSIS, what is available?Mon, 17 Sep 2012 21:38:24 GMTEvil Kraig Fhttp://www.sqlservercentral.com/Forums/Topic1360534-391-1.aspxI 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.Mon, 17 Sep 2012 20:44:09 GMTeh.shams