am trying to purge the millions of data.. for that am inserting the data into one table and executing the job but job running successfully but still data remains same
There's no SQL Server provided "purging job" that will help you here. You'll need to dig into the custom purging job that you're talking about and find out what you need to do to get rid of the data. Just copying data from one table to another doesn't mean any purging job is going to recognize your action and so you have more work to do.
If you want more help here, you're going to need to post your code, the code that the supposed "purging job" is running, and the CREATE TABLE statements for both tables including any indexes and triggers on either table. If you have any FKs pointing at the original table, you should include those, as well.
17 People are following this question.