August 29, 2005 at 10:17 am
I am experiecing a strange issue on my SQL Server 7.0 server running 7.00.1063 on Windows 2000 sp 4. Although the jobs seem to run fine both manually and automatically, when I try to send a test message from an operator I recieve the following message:
Unable to test this address because the SQLServerAgent service is not running.
Even though the jobs seems to be running fine. Help!!!!!
Arthur Lorenzini
August 30, 2005 at 4:18 am
Have you setup a MAPI mail profile (Outlook) for you SQL Server Agent account? Then have you gone into SQL Server AGent properties and assigned this profile?
SQL Agent Mail is a little weak. I hope it has been improved in SQL 2005. If I had the time I would write my own monitoring procedures and use SMTP Send Mail (can be found on this site)
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
August 31, 2005 at 8:07 am
Is the SQlAgent Mail tied to SQL Mail because if it is, I am able to use xp_sendmail without any issues.
Arthur Lorenzini
August 31, 2005 at 8:15 am
Sql Agent Mail and SQL Mail are 2 different processes. SQL Agent Mail does NOT use xp_sendmail.
IN the properties of Sql Server Agent ther is a place to assign the Mail Proficle just like in SQL Mail.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
September 1, 2005 at 12:16 pm
I setup backup jobs using db maintenance wizards. but sql server agent keeps on popping in command mode. What is the problem
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply