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.

All Forums  SQL Server 2008 Forums  SQL Server Administration (2008)  Data Base mail Not showing any logs

Author  Topic  lolstorm Starting Member 1 Post Posted - 2011-06-21 : 19:09:07 hello im trying to use database mail to send emails with SQL but im with a big error atm don't know what's hapening with my SQL server: i already put all my domain settings on data base mail wizard and activated the database... When i use this procedure to sent an email: EXEC msdb.dbo.sp_send_dbmail @profile_name = 'Data base mail profile 1', @recipients = 'blabla@hotmail.com', @subject = 'Esfdfsfg ', @body = 'dadsa' It says the mail were queued and if i do this query i can see all the mails i tryed to send: SELECT * FROM msdb.dbo.sysmail_allitems But when i try so send to execute this one to see if the email were sent without any problems: SELECT * FROM msdb.dbo.sysmail_event_log i only get 1 row "The mail queue was started by login "user". which was when i started the database service i think but all those mails who are in all items table doesn't show here and i can't see the mails on my mailbox after... well i have some other problems which can be related to this my SQL jobs are currectly working but they don't post on the tables fields like "last run" and i can't see when job run... At SQL agent i got this errors maybe this is related but i already tryed to search on the web and didn't saw any solution for this: 298] SQLServer Error: 229, The EXECUTE permission was denied on the object 'sp_sqlagent_log_jobhistory', database 'msdb', schema 'dbo'. [SQLSTATE 42000] (ConnExecuteCachableOp) [298] SQLServer Error: 229, The UPDATE permission was denied on the object 'sysjobservers', database 'msdb', schema 'dbo'. [SQLSTATE 42000] (ConnExecuteCachableOp) Message [298] SQLServer Error: 229, The SELECT permission was denied on the object 'sysjobservers', database 'msdb', schema 'dbo'. [SQLSTATE 42000] (ConnExecuteCachableOp) Message [364] The Messenger service has not been started - NetSend notifications will not be sent Any help it's really appreciated Ty Ricardo lolstorm