-
Automatic email notification
Hello
i am new to sqlserver 2000.i have list of email id in a table. need to fetch that emailid and send mail to the appropriate id's.any body knows how to write job schedule for this task.Ideas are welcome
Last edited by jbalanvasu; 12-26-2007 at 12:16 AM.
-
Write a stored procedure for this then run the sp as scheduled job.
-
hello rmiao
Thanks for your response. i am mot familiar with stored procedure. but i have tried with xp_sendmail. but cannot get output.can u please
help me.if possible post the stored procedure
-
Did you enable sql mail on the server yet?
-
Hello rmiao
do you asking about enabling sqlmail based on outlook profile. i tried . but when i executing xp_sendmail the following error shows
Cannot load the DLL sqlmap70.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.).
do you have any idea
-
Does sql mail start? If not, how can you send mail in sql?
-
Hello rmiao
i have started sqlmail. but still it shows the same error
Cannot load the DLL sqlmap70.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.).
Last edited by jbalanvasu; 12-28-2007 at 05:15 AM.
-
Sounds mapi client doesn't work properly, tried re-register sqlmap70.dll?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|