Solved

SQL SERVER 2005 job notification

Posted on 2007-04-09
1
578 Views
Last Modified: 2010-08-05
I set up an notification for a job that I have running in SQL SERVER 2005.  I know that the database mail is set up properly because I had it send a test email to my email addresss and it worked fine.  But, for some reason I keep getting this error message every night when the job finishes.

[264] An attempt was made to send an email when no email session has been established

Can anyone tell me what I am doing wrong?  Thanks

0
Comment
Question by:skielark
1 Comment
 
LVL 20

Accepted Solution

by:
Sirees earned 500 total points
ID: 18877814
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Not selecting duplicate data 6 60
Strange msg in the SSMS pane 13 58
Sql query 107 73
Need help how to find where my error is in UFD 6 40
There are some very powerful Data Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a discu…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question