Post reply

SQL Server 2000 agent in performing completion action status

  • July 7, 2011 at 4:57 am

    #243710

    I am using SQL server 2000.i have one job which will extract data from one server after that it has to send mail to particular team.The problem is it will complete the extraction but it will not send the mail.It will show the status as 'performing completion action '.It happens only some time...

    Now i need to submit the root cause for this error.Can anyone please help on this

  • July 7, 2011 at 5:10 am

    #1349558

    shanila_minnu (7/7/2011)

    I am using SQL server 2000.i have one job which will extract data from one server after that it has to send mail to particular team.The problem is it will complete the extraction but it will not send the mail.It will show the status as 'performing completion action '.It happens only some time...

    Now i need to submit the root cause for this error.Can anyone please help on this

    Without anything how can we help.

    Could you provide the scripts?

    If your condition is statified then you ll get an email.

    Muthukkumaran Kaliyamoorthy
    https://www.sqlserverblogforum.com/

  • July 7, 2011 at 7:21 am

    #1349674

    Hi ,

    Looks like your SQL Job is fine and trying to send the notification mail but your exchange server is unavailable or something wrong on that side.

    The below link will be detailed help while you getting status of "Performing completion actions."

    http://support.microsoft.com/kb/328197

    Thanks

    Imran

  • July 8, 2011 at 4:27 am

    #1350231

    thanks Imran...this is wat i am expecting

Viewing 4 posts - 1 through 3 (of 3 total)

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