In your first scripts SELECT statement, I dont see any logic or filters in the WHERE condition where you're telling it to exclude the old data and select new data.

I think what you could also do is build a temporary table, transfer new data into that using a datetime column and just do a simple SELECT against that. The SQL Agent job will not cause replication because this is purely SQL-code related issue.

Thanks,

S