Is it possible to make so that in the task one step is carried out according to one schedule, and the other - according to another schedule, that is, so that the steps do not depend on each other?

  • four
    and two tasks do not do what? - teran
  • Author, did you succeed? Maybe there are questions? - Serge Nazarenko
  • @SergeNazarenko yes, everything worked out, thanks - kosmo_tony

1 answer 1

It is possible - for this you need to do 2 jobs in the following way:

  1. The first job should start with step 2, running on schedule number 1.
  2. For step # 1, you need to set the job completion setting upon successful execution, if you do not want step # 2 to be executed according to 2 schedules.
  3. The second task will be called using sp_start_job Job number 1 from step number 1 on schedule number 2.

But I don’t see the point of such a decision, but maybe if you described the whole task, the meaning would become clear.