Post reply

Help - Send Email Task quit working in DTS packages.

  • November 9, 2006 at 10:07 am

    #69145

    I have several DTS packages that contain the Send Email Task in order to send myself emails of job status (i.e. "Job Failed - File not updated", "Job Failed - check transformation", "Job Completed - Yea!", etc).

    These have been working fine until last Friday (11/3/06) [worked fine for over a year]. Network administrator swears no changes have been made to the Exchange Server or the SQL Server 2000 server.

    These jobs are scheduled under the SQL Server Agent.

    I can add a notification to be emailed under the Notifications tab of the job properties dialog (SQL Server Agent -> Jobs) and it WILL send an email here if job completes or fails.

    If I run the DTS package manually, the Send Email Task works - it just does not seem to want to work anymore when the DTS package is a scheduled job under the SQL Server Agent.

    I checked and there's not been a Windows update applied since 10/12. I suspect it has something to do with user rights, but these jobs are run under administrator or sqlexecutive ownership - and again - no one claims to have changed anything that affects this.

    Has anyone experienced this? What caused it and what's the fix?

    Thank you in advance,

    Billy Hildebrand

  • November 9, 2006 at 10:43 am

    #670893

    Are you using Outlook as the MAPI client ?

    If you open Outlook as the same user that SQLAgent uses, can you access your mailbox and send mail ?

  • November 9, 2006 at 12:00 pm

    #670906

    Yes, Outlook is the MAPI client [MS Exchange Settings] and I can access and send email with same user that SQLAgent uses [tried both domain/administrator and domain/sqlexecutive].

  • November 10, 2006 at 2:14 am

    #671021

    Which service pack are you using?  This was a well known bug in SQL 2000. SQLMail would just stop responding. The problem was greatly improved by service pack 4, but not completely fixed. The only fix is to stop and start SQL Server though I generally just rebooted the whole server (It's Windows after all, and good reboot never hurts).

    My blog: SQL Soldier[/url]
    SQL Server Best Practices:     SQL Server Best Practices
    Twitter: @SQLSoldier
    My book: Pro SQL Server 2008 Mirroring[/url]
    Microsoft Certified Master: SQL Server, Data Platform MVP
    Database Engineer at BlueMountain Capital Management[/url]

  • November 10, 2006 at 5:37 am

    #671048

    I re-booted yesterday and everything is working again .

    Thanks

    Billy

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

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