can u plz elaborate on this global executor , expressions and constraintsthings more coz its seems to be the solution to my problem.

if i include the steps of other locations in that job only,than what will happen when i want to run job of only one location.

and afterwards many locations will be...

cant i execute the jobs one after the other?

Can u plz write down the steps. As I m unable to find the type to run the job inside a job. I m using the type as SQL Server...

hi amit this is parwinder, could you please elaborate your method to upsert into dest table.