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 ?

enter image description here

on way accomplish using maintenance plan.

  1. add two: execute sql server agent job task.
  2. configure jobs.
  3. link both jobs.
  4. force execution of second job after success or completion of first one.

Comments

Popular posts from this blog

account - Script error login visual studio DefaultLogin_PCore.js -

xcode - CocoaPod Storyboard error: -