1

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)?

3
  • 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, 2015 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, 2015 at 10:21
  • This is only a workaround. A question is still valid.
    – huhu78
    Jul 3, 2015 at 10:22

1 Answer 1

1

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)

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .