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 |
|
SQLDiva
Starting Member
26 Posts |
 Posted - 2007-01-28 : 10:36:30
|
| I'm SO frustrated!I have a DTS package (actually, several) that include email alerts. SQL Server services (SQL Server and the agent) are running under an administrator account. When logged in as that administrator, I can execute the dts package fine and the emails send. If I schedule the dts package to run it fails when it gets to the email alert. However, if I right click and schedule it runs fine. It's only when I use code like below to schedule that it fails (this runs fine on other servers). I can't use the right click and schedule because they need to be multiple step jobs. This is on a new server, and the exact jobs ran fine on the other server. DECLARE @Result INTEXEC @Result = xp_cmdshell 'DTSRun /S "SERVERNAME" /N "nameofdts" /W "-1" /E' IF (@result = 0) PRINT 'Success' ELSE RAISERROR ('nameofdts failed',19,1) WITH LOGI feel it has to be something with how I have everything configured, but everything I know to check is the same between servers.Ideas? |
|
|
|
|
|
Email failing! HELP!