Post reply

Performing Completition Tasks

  • April 19, 2006 at 1:47 am

    #91629

    We are getting an error message as follows "Performing Completition Tasks" from a number of Jobs. It happens intermittantly but seemingly more and more often. It is happening to jobs that have previously worked without problems for months. Does anyone have any suggestions what the problem might be.

  • April 19, 2006 at 1:11 pm

    #633131

    Ah... The "Performing Completition Tasks" hatred message

    This is very related with the email subsystem that your SQL SERVER AGENT is using. it tends to happen when the conectivity is lost with the exchange server while the agent is performing an email notification.

    Resolution.

    1. Ensure you have your exchange server stable.

    2. Fix the Outlook profile like so: 

          --  Remove address book and contacts from it

    3. Cycle SQL Server Agent

     

    Cheers, 


    * Noel

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply