job schedule in sql server script for select and insert query,
i want only the script (every time check for new records if have
(compare datetime) latest records its automatically inserted in
database) of job scheduling in sql server.
SELECT calldate,duration,userfield FROM vcall WHERE calldate > '2012-04-08 16:04:56.000' Order By
calldate desc limit 100"
please give the correct solution and the script for this.