64-Bit SQL Server 2005 (Enterprise), SQL Agent Notifications and Database Mail

We have database mail configured on our 64-Bit SQL Server Enterprise 2005 (SP1) and are able to send test messages from the context menu that appears when selecting database mail component.

However for some reason when a SQL Agent Job fails, no emails are sent to the 'operator' that has been defined for the job. I have confirmed that we have the operators correctly configured. We also have a small SQL Agent Job that just sends a test email via the sp_send_dbmail command and that works properly. However if I deliberately create a malformed parameter in the sp_send_dbmail command to 'break' it...no notification of a job failure message is sent.

I have verified that the service_broker component is enabled...and the status of database mail in the MSDB database is 'started.'

We have setup several other 32-bit SQL Server 2005 systems using database mail...and they all work flawlessly.

After reviewing existing message posts...I am unsure if there is a problem with database mail on a 64-bit SQL Server box. Some say 'yes' other say 'no'.

There are several MSDN notes about the problem...however these appeared prior to the release of SP1 of SQL Server 2005.

Thank you for your assistance.

...cordell...

SQL Database mail which relies on using your SMTP server instead of a mail client to send out email, so check whether that service is started as a first point of check.|||

yes..our Exchange server works properly and is running. I have several other 32-bit SQL Server 2005 system that are able to send email (using SQL Database Mail) without issue.

Maybe I have misunderstood your reply and missing something obvious...since this is a pretty basic question.

Thank you.

...cordell...

|||

As I read KB article 908360 it says that SQL Server 2005 (x64) is not integrated with Database Mail or with SQL Mail in Microsoft SQL Server 2005 64-bit editions.

But then there is a note that says, "Note In SQL Server 2005 Service Pack 1 (SP1), you can use SQL Server Agent to interact with Database Mail as the mailing system on 64-bit operating systems."

We have SP1 installed on our x64 SQL Servers but Database Mail still doesn't work with SQL Agent. The history for any job that fails says, " NOTE: Failed to notify 'DB_Engineering' via email."

QUESTIONS:

Is it correct to assume that there is one and only one SP1 package for SQL Server 2005? Our assumption is that the currently available SP1 is for both 32 bit and 64 bit SQL Server 2005 installations.

Does a separate 64 bit SP1 exist somewhere?

Are there special instructions required for setting up database Mail on SQL Server 2005 (x64) SP1 without using Outlook Express? If so, we haven't found them yet.

Does this article really mean that Outlook Express is currently the only workaround for using Email Notifications on a 64 bit SQL Server? (We do not activate Outlook Express -- or even SMTP -- on Production SQL Servers. SMTP exists on its own machine.)

Please advise,

Thanks,

Ernie

5 key sprocs used for replication

Can you please list 5-10 important sprocs being frequently called by the log
reader and distribution agent in a transactional replication setup and in
one line explain what they do ?
Thanks
Hassan,
have a look at this page in BOL:
mk:@.MSITStore:C:\Program%20Files\Microsoft%20SQL%2 0Server\80\Tools\Books\tsq
lref.chm::/ts_sp_00_519s.htm.
HIlary's book will explain the relevant ones, but I'd recommend
sp_addpublication, sp_addsubscription, sp_addarticle, sp_browsereplcmds,
sp_replcmds. I won't describe them as BOL does a good job already. To see
the key stored procs for your particular scenario, create the publication
and subscriptions in Enterprise Manager then get EM to script out the
publications and examine the scripts.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Actually I wanted to know the key sprocs that run once the transactional
replication is already setup. Sprocs that run that the log reader and
distribution agents call. Also any other sprocs that run on a constant
basis.
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:ucJXtws6EHA.3236@.TK2MSFTNGP15.phx.gbl...
> Hassan,
> have a look at this page in BOL:
>
mk:@.MSITStore:C:\Program%20Files\Microsoft%20SQL%2 0Server\80\Tools\Books\tsq
> lref.chm::/ts_sp_00_519s.htm.
> HIlary's book will explain the relevant ones, but I'd recommend
> sp_addpublication, sp_addsubscription, sp_addarticle, sp_browsereplcmds,
> sp_replcmds. I won't describe them as BOL does a good job already. To see
> the key stored procs for your particular scenario, create the publication
> and subscriptions in Enterprise Manager then get EM to script out the
> publications and examine the scripts.
> Rgds,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
|||Hassan,
the easiest way to setermine these procs is to run profiler, trap the
relevant events (SP:Starting...) and then run the distribution agent.
Rgds,
Paul Ibison

3rd party Backup Software and MSSQL 2000

Can SQL 2000 initiate backups to 3rd party applications (like LiteSpeed
and BrightStor's SQL Backup Agent)? My goal is to be able to manage
backup and restores completely through SQL Enterprise Manager and Query
Analyzer without having to logon to the Server and using the 3rd party
backup application's software. Is this possible through SQL?

Thank you,
Stephanie"Stephanie" <stuttle@.centene.com> wrote in message
news:1125609584.963975.200390@.g44g2000cwa.googlegr oups.com...
> Can SQL 2000 initiate backups to 3rd party applications (like LiteSpeed
> and BrightStor's SQL Backup Agent)? My goal is to be able to manage
> backup and restores completely through SQL Enterprise Manager and Query
> Analyzer without having to logon to the Server and using the 3rd party
> backup application's software. Is this possible through SQL?

Yes.

> Thank you,
> Stephanie