?
Solved

SQL SERVER 2005 job notification

Posted on 2007-04-09
1
Medium Priority
?
584 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 2000 total points
ID: 18877814
0

Featured Post

NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

Question has a verified solution.

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

by Mark Wills PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type transformation where we need the information held as data within a column to become columns in their own right. Now, in some cases that is relatively…
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…
Integration Management Part 2
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …

864 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