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 - 2002-02-26 : 22:39:25
|
| Bonny writes "Hi there,I've got a weird problem: I have a package which is composed of a number of 'Execute Process Task' steps, which run queries against a database. When executed from Enterprise Manager, it runs to completion. This is also the case when running the package from the command line using dtsrun.However, when running it as a job in SQLAgent, using dtsrun, the package starts execution but blocks executing the first step, and never completes. It seems that some sort of semaphore is waited upon, but never released...SQLAgent is set up to use a user account which is an Administrator for the machine on the NT domain the machine is in, as well as the dbo for the database in question. Also note that this is the same user that is logged on when the DTS package was run from the Ent. Mgr and the command line described above.I've tried the on line help, but is shows nothing about this...Cheers,Bonny" |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2002-02-26 : 22:42:07
|
| Hi BonnyI have had some fun with this lately. We had a bunch of DTS jobs that stopped running.Turns out that the user account they were created by had it's password changed. These had been scheduled by clicking "Schedule Package" in DTS. When that happens, a job is created that uses DTSrun followed by some sort of hash of the server name, user name and password. When the password was changed, all the jobs died.Maybe try deleting the job and rescheduling it.Damian |
 |
|
|
|
|
|
|
|
DTS Package executed from SQLAgent is blocked