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 |
|
cthompson
Starting Member
11 Posts |
 Posted - 2005-07-06 : 11:26:19
|
| Hi GuysI have been able to send e-mails(by outlook) to various staff when an DTS process has either successfully completed of failed so that the staff would know.The issue is that when i create a scheduled process of the DTS package it is unable to finish and when i tested and changed the DTS process without sending e-mails. The scheduler was successful.Does anyone have an idea why the schduler would fail when the DTS process, when ran manually is able to succeed.Thanks is advance for any help.RegardsChris |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-07-07 : 06:39:59
|
| when you run the package, it runs under your account, if you schedule it, a job is created and it runs under the context of whatever account that owns the job, check for the account's permission--------------------keeping it simple... |
 |
|
|
|
|
|
Sending E-mails via DTS