I did start a Maintenance Plan project with Execute SQL Server Agent Job Task box. I added another task on success event. I realized that I was wrong. The second task is executed in parallel, because first task executing was successful (executing but not completing - important reason).

So question is - can I connect second task in that way, that the first task (agent job) is fully completed (not just fired)?

  • In fact a first job was a single step backup - so it was to exchange it to database backup task - and a case is solved - but the question is still open. – huhu78 Jul 3 '15 at 10:16
  • You can answer your own question- and if you've genuinely solved the problem, please do so others will benefit. If you still have a question, please edit to reflect what is yet unanswered. – cxw Jul 3 '15 at 10:21
  • This is only a workaround. A question is still valid. – huhu78 Jul 3 '15 at 10:22

When you start an agent job, it returns immediately with a success message.

Take a look at this post (http://agilebi.com/cs/blogs/jwelch/archive/2009/02/20/check-for-sql-agent-job-completion.aspx)

|improve this answer|||||

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.