March 29, 2007 at 3:34 am
Hi
I'm using SQL 2000 and written several jobs. I'm using SQL Alert for all the jobs. Sometimes we do not receive mail in outlook. In the log file, it shows an error message:
The job succeeded. The Job was invoked by User sa. The last step to run was step 1 (1). NOTE: Failed to notify 'Amit' via email.
I'm using MS Outlook 2003 and SQLSERVER agaent service is started as .\Administrator. From the MS Outlook, outgoing is working fine. Sometimes i receive message while opening Outlook : 'xxx.pst file is accessed by some other application....................' and closed it automatically.
Can somebody help on this?
Amit
March 30, 2007 at 3:08 am
Log on with the SQL service account. Check the following:
1) Can you start Outlook manually
2) Check the mail account. Everything should be stored in the Exchange mailbox. If you are using any features that need a .pst file (e.g. Address Book) remove them. You need to be running Outlook without a .pst file to maximise reliability (even then you will get odd problems...).
2) Is the Outlook profile defined to SQL Agent
3) Run a job that will send a completion message, is the message sent?
4) If nothing was sent in 3) , run xp_stopmail and xp_startmail, then repeat step 3.
If you have any SPs or user code that is using SQL mail, remove all references to xp_stopmail and xp_startmail. Mail is started automatically when SQL starts, so and use of xp_stopmail could prevent other users from using mail.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply