Hi,

I have parent and child package architecture where in i m using ServerexecutionID to find status of each packages and if any child package/s fails , i am stopping all packages for further execution. Problem here is , when i run the packages from catalog , all packages works fine and i am able to read ServerexecutionID , but same is not available when i create a SQL job. 

SQL jobs i am running through SQL server agent job.

I m  not understanding why i am not able to read ServerexecutionID by SQL job.

Please suggest.

Thanks.