hii have a table from navision PLSo that is being updated every hour now i have created a table on my server PLSy now i want PLSo to update PLSy after 30 min it has got that info .. i don't mind doing it by my self if i cannot schedule it..Please help with the statement.. PLSo has a field that is never duplicated so i used it to say PLSo give everything(new rows that are captured on you) that PLSy do not have

select * into [PLSy] from [srv5].[DB].[dbo].[PLSo]--Navisionwhere [timestamp] not in (select [timestamp] from [PLSy])

I tried using this statement it does not work since the table is there so for the past week i have been deleting and re creating this table