Terence - Yep I know that if I change the job step to run at the full file path for using dtexec or dtsrun it will probably work but unfortunately that means changing the job step on a production database which requires a ton of sign off.

Thanks for the suggestions on this one guys