I have a SQL job (main job) that has multiple steps:

1. Update job params - this is a SQL script that calls a stored procedure which updates the parameters of step 2 and 3
2. SQL job1
3. SQL job2
4. Log process

Now, when I run the main job, it updates the parameters of jobs 2 and 3 and it works.

After the first iteration is done, I'm trying to update the jobs 2 and 3 with different parameters values, but in vain.

The jobs run with initial parameters only.

What could be the issue? Can't we update those params?

Apologies for not pasting any code.