• Thanks Craig and Chris for the reply,

    I have run the query on both the servers will post the execution plan once it runs, normally when running the same query independently (Not running the Job) takes around 6 hrs on one server and around a day on another 🙁