FIXED! xp_sendmail works from QA but not from DTS package
From: Colleen Rossman (crossman_at_discussions.microsoft.com)
Date: 11/22/04
- Next message: Adam Machanic: "Re: int or char for area code and phone number"
- Previous message: ChrisR: "int or char for area code and phone number"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 22 Nov 2004 10:43:02 -0800
I have finally figured out how to get this to work in DTS. I needed to
specify the '@recepient=','@subject=' and @message=' variable names. In
Query Analyzer I didn't need them. I could just issue xp-cmdshell
'myemail.com','test message'
"Colleen Rossman" wrote:
> Yes, we're using the same accounts for both services. However, yesterday it
> worked. This isn't the first time this has happened.
>
> Colleen
>
> "Steen Persson" wrote:
>
> > Do you use the same account for running both your SQLServer service and your
> > SQLAgent service? If not, then try to set SQLserver to use the same account
> > as SQLAgent - the one that has the mailbox set up.
> > I have had similar issues where it was solved by having the SQLserver
> > running on the same account as SQLagent rather than the local system.
> >
> > Regards
> > Steen
> >
> > Colleen Rossman wrote:
> > > The 'error' message is 'successfully executed step' but I never get
> > > the e-mail. Yes, we setup a MAPI profile for SQLAgent Account and it
> > > successfully stops and starts a mail session using that account. It
> > > works on all our other servers. I've had this problem at other
> > > companies too, and have never figured it out.
> > >
> > >
> > > "Rick Sawtell" wrote:
> > >
> > >> What error message are you getting back?
> > >>
> > >> Did you create an email profile for whatever account the DTS package
> > >> is running under?
> > >>
> > >> Rick Sawtell
> > >> MCT, MCSD, MCDBA
> > >>
> > >>
> > >>
> > >> "Colleen Rossman" <crossman@discussions.microsoft.com> wrote in
> > >> message news:646B361E-002D-4958-A5C2-16FCC3ACDD78@microsoft.com...
> > >>> I copy and paste from QA to DTS so I know it's not a typo. I ran
> > >>> xp_stopmail and xp_startmail and still no l luck. We bounced the
> > >>> SQL Agent too but it's still not working. SQL mail is working
> > >>> though.
> > >>>
> > >>> Please help!
> >
> >
> >
- Next message: Adam Machanic: "Re: int or char for area code and phone number"
- Previous message: ChrisR: "int or char for area code and phone number"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
