After a long time, I am writing something. Just thought of writing as I spend so much time in this.
Issue in scheduling task; data updating; not inserting.
Solution: Make sure you are reading data from table not from a view. if its from view, only updations will happen; no insertions.
Check SP and make sure you are executing as a caller.
