DTS Runs but Scheduled DTS does not

[Malcav]

Hi
I have a DTS on our server and when I log on to the machine and manually execute the dts it runs through fine. However when I schedule it and start the job it get through the first step and then stops. I does not error or anything just sits there saying it is running but it is not.
Not sure weather it has any influence but the second step is moving data from a notes db to the server.
I was working a week or 2 ago but now i have to do it manually every morning.
THanks for any help
Malcav

 

[AlexCuse]

First thing to check is usually permissions on the SQL Server Agent account. You will want to see if it has permissions to every database object that it needs.

Hope this helps,

Alex

[small]----signature below----[/small]
I don't do any programming whatsoever

Ignorance of certain subjects is a great part of wisdom

 

[nomadicalloy]

I usually run the jobs under "sa" account in sql 2005.



This is Signature

http://www.xpherion.com/

 

[Malcav]

Its cool. there was a dead notes session running in the background. For some reason this does not effect the manual running of the dts but it stops the sql job in its tracks.
SOmething to keep in mind for futur reference.