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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-03-06 : 07:26:27
|
| Shailaja writes "Hi there,I have a problem. I have this particular file that has some queries to update the database and depending on the results, I need to send some mails to the user. Now this particular file needs to be run daily. I tried out various methods to run it from my code but the problem I am facing is, I can't trigger it automatically.Now the solution I found was to fire a job daily to make the updataions and send mails using SQL Mail. This, unfortunately, is not supported by my server. I also found another solution viz. to create an object instance of the mail by using the extended stored proc "sp_OACreate", but for this also we need execute permissions on the master database, which again my server does not provide.Please help me out with this. Can we send mails through SQL?? If yes, please explain me as to how to go about it without bothering abt any permissions from the server.Thanks in advance....Regards,Shailaja" |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-03-06 : 08:24:48
|
| Can you put the emails intoa table then have a scheduled job to send the emails run under a user that does have permissions.Either that or write an app to query the table and send the emails.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Sending mails through SQL Server