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 |
|
kwilliams
194 Posts |
 Posted - 2004-05-06 : 14:38:07
|
| I've created a DTS package that has a simple "Send Mail" Task job that emails some information daily to a fellow employee. When I manually execute the package, it works great. But when I schedule the package, the scheduled job fails. If I try to run the job directly, it still fails. Has anyone else ever seen this, or does anyone have an idea of why this is happening? Thanks for any & all help.KWilliams |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-05-06 : 14:41:39
|
| Is the SQLSERVERAGENT configured to logon with the Exchange account? Also, what is the error?Tara |
 |
|
|
kwilliams
194 Posts |
Posted - 2004-05-06 : 14:49:38
|
| The manual run of the job results in this error:The job failed. The Job was invoked by User SERVERNAME\USERNAME. The last step to run was step 1 (PACKAGENAME). NOTE: Failed to notify 'USERNAME' via email...and the scheduled run of the job results in this error:The job failed. The Job was invoked by Schedule 76 (PACKAGENAME). The last step to run was step 1 (PACKAGENAME).Concerning your question, "Is the SQLSERVERAGENT configured to logon with the Exchange account?", I'm not sure of the answer, but I'm asking my Network/System Administrator.Just so you know, I tried changing the owner from me to "sa", but it didn't result in anything. Do you have any suggestions with what I'm able to post?KWilliams |
|
|
|
kwilliams
194 Posts |
Posted - 2004-05-06 : 14:52:48
|
| Tara,Here's the answer to your other question:"The SQLagent service runs under a special domain account that he has just for it and the main SQL service."KWilliams |
|
|
|
kwilliams
194 Posts |
Posted - 2004-05-06 : 15:25:35
|
| After some troubleshooting, we discovered that it's working on the DTS pkg because I'm manually running it from my computer, as opposed to it being directly run from the server. When the pks is run fro the server, it fails. I now understand that the only way to set this up is to install Outlook on our server, but my NA is hesitant to do so. So I'll have to figure out some sort of workaround that will utilize emails from a DB table, and email jobs to those email addresses. If I ever do come up with a solution, I'll let you know. Thanks for your help Tara.KWilliams |
|
|
|
|
|
|
|
|
Job Works Manually...But Not When Scheduled