Sql server agent job task

• Question

• 

  

  0

  Sign in to vote

  Hello,

  I have below requirement,pls guide me at your earliest.

  　1. Set the job 'Job1' with the logic that if the job fails it should keep the 'Job2' as disabled.If the 'Job1' successfull then it should enable the 'Job2' so it will run at scheduled time at 4am daily.

  2. When the 'Job2' runs successfully it should end as success with disabling the 'Job2' again.

  3. If the 'Job2' fails still it should report as failure and disable the job.

  Sunday, November 27, 2011 7:28 AM