Schedule a job to run only if another job is not currently running in Microsoft SQL Server Management Studio -
currently have 2 jobs can't run in parallel. there way can defer execution based on status? mag_logicar_d3_h should not run if mag_logicar_d3_m running , vice versa using microsoft sql server management studio ?
on way accomplish using maintenance plan.
- add two:
execute sql server agent job task
. - configure jobs.
- link both jobs.
- force execution of second job after
success
orcompletion
of first one.
Comments
Post a Comment