For information sp_start_job is asynchonous, this is the problem .....

I've seen also that sysjobactivity contains several lines per jobs.

For information i have implemented this using two stored procedures:

- the first one called "uspTECH_GET_JOB_RUNSTATE" ...

Hello,

In fact as mentioned in this forum, the sp_start_job is not synchronous, so you don't know if the job has failed of not.

Moreover, to execute a job you must be...