Good day, Is it possible to Execute Step2 in Agent without waiting for it to complete, just trigger and go immediately to step3? If so please explain. Regards

Yes. See http://social.msdn.microsoft.com/forums/en-us/sqldatabaseengine/thread/0D9A7C80-A57A-482B-BED5-0AE7AE64BFBB "create a second SQL Agent job (Job B), and change step 2/3 in Job A to execute Job B"Arthur My Blog

To start sql job with T-SQL here is sample exec sp_start_job @job_name='The Second Job' GO http://uk.linkedin.com/in/ramjaddu

Thank You, i can only really test this once my pkg is fixed - will give it a try tomorrow. Ramjaddu - i dont understand, should i create T-SQL job to execute another job - but wont that wait for the called job to complete first before going to next job

Apologies, my job/pkg i wanted to do the split does not work to exectute on remote PC So i cant try it - Thank You All