They are the same stored procedure that runs in QA and via jobs.

I have added 'with recompile' to the stored procedures but that has made no difference to the speed.

There are scheduled jobs that overlap but only due to the time they take to run via jobs.  They are scheduled two hours apart and when run through QA they would finish in plenty of time.

Also the scheduled jobs are on different databases so I assume this would not affect them in this way?

I have tested a stored procedure by running it via jobs when nothing else has been running on the server yet it makes no difference to the speed.

If I cannot speed up the job in SQL then I will look into manipulating the data outside of SQL then loading the data in.