Re: Sending Email from a job with ActiveX

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: james rimell (jim)
Date: 02/22/05 

Date: Tue, 22 Feb 2005 09:15:53 -0000

Thanks I will take a look

"Alien2_51" <dan.billow.remove@monacocoach.removeme.com> wrote in message
news:15CFB464-ABFD-4B89-8E8F-15ACA4BC2D63@microsoft.com...
>I recommend using an SMTP mailer... Toss SQL Mail it requires you to
>install
> a big fat MS Outlook MAPI client on the server and configure a mail box,
> not
> good, major pain...
>
> I'm using this... works like a charm...
> http://sqldev.net/xp/xpsmtp.htm
>
>
> "microsoft news" wrote:
>
>> I am creating a Job using the SQLDMO interface, if the job fails I want
>> it
>> to email someone with an appropriate error message.
>>
>> On some servers this works fine and on others it doesn't, it all seems to
>> depend on the mail profile settings. The wierd thing is that an activeX
>> script that doesn't work from within a job will work straight from a DTS
>> package
>>
>> can anyone tell me if there is any way that I can set up the email to
>> work
>> everytime or set up the server to use the same email settings for
>> Packages
>> and Jobs
>>
>> thanks
>>
>> JR
>>
>>
>>

Relevant Pages

  • TSLSA-2007-0007 - multi
    ... Affected versions: Trustix Secure Linux 2.2 ... The mod_php module enables the Apache web server to ... The postgresql package includes the client programs and libraries ... SECURITY Fix: Fetchmail does not properly enforce TLS and may ...
    (Bugtraq)
  • Re: remotely call a DTS
    ... Allan Mitchell wrote: ... Denied on something inside the package. ... This worked when I was logged into the server and ran it from my ... but the DTS blows up. ...
    (microsoft.public.sqlserver.dts)
  • Re: sunmanagers Digest, Vol 34, Issue 14
    ... Christopher sent me a link to ftp.cs.tu-berlin.de that has all patches sun ... Subject: SUMMARY: Setting up mail on a Solaris Server ... however I seem to be having issues finding a binary package. ... Problems while installing 108528-29 for Sol8 machine ...
    (SunManagers)
  • Re: DTS Environment Control
    ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. ... When run from the production environment, the production server is accessed and when run from the test environment, the test server is accessed. ... For simple packages it's not too big of deal - but for more complete ones - you can spend an hour carefully changing all your connections. ... I had one solution where we would add an ActiveX script task as the very first step, that would determine what SERVER the package was executing from - and based on that would dynamically change all the connections by looking up the package name and server from a DB. ...
    (microsoft.public.sqlserver.dts)
  • [Full-Disclosure] LNSA-#2004-0006: bug workaround for Apache 2.0.48
    ... Package name: apache ... The Apache HTTP Server Project is an effort to develop and maintain an ... We recommend that all systems with this package installed be upgraded. ...
    (Full-Disclosure)