Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bensteph
Starting Member
3 Posts |
 Posted - 2004-09-13 : 10:25:50
|
| Hi,I've tried to send mail without sql mail , using CDO message ( I used differents information on this forum and other), and it works good...But the problem is that I cannot send alert with informations such as error code, database name ....I've find this solution : http://www.sql-server-performance.com/dh_sending_sql_notifications_CDOSYS.aspand each step works fine except the most important for me...The solution in is the use of token agents, but I cannot make them work,even when i copy the procedure from the link above :------------------------------------------------DECLARE @msg nvarchar(4000)Set @msg = REPLACE("Error: [A-ERR]Severity: [A-SEV]Date: [STRTDT] Time: [STRTTM]Database: [A-DBN]Message: [A-MSG] ", "'", "") --' EXEC sp_send_cdosysmail 'from@emailaddress.com*','to@emailaddress.com*', 'subject*', @msg------------------------------------------------------Any idea ?Thanks for help |
|
|
|
|
|
Need help for CDO message and token agents