After this job - disabled

[dz_IT]

Hi,

We have this situation: for the time of restarting SQL servers I set Disable for the backup job, because of the backup of transaction logs. There are situations that we forget to re-enable SQL backup jobs and subsequent jobs will not start at the specified time, because they are set to "After this job: SQL Servers".

Is there any option to set that when a job is in Disable mode, the next one is supposed to run in the queue?

[Mildur]

Hi DZ

No, if the first job is disabled, all other jobs chained to the disabled job will not be started.
Could you tell us the use case why you need to use job chaining? Our recommendation is to use time based scheduling of the jobs.

Thanks
Fabian