February 24, 2003 at 9:57 am
Check if owner of the job, that runs packages has changed or privileges to this owner has changed.
February 24, 2003 at 11:12 am
What is the error message you received when the DTS package fails?
Diane
February 24, 2003 at 3:29 pm
The user of the scheduling is the sa user which points to a generic user call SQLExecutive from a different domain. It was such a coincidence that once the system guy looked at the permission, the jobs all of a sudden started working. My thought is that these permissions were dropped and then added. Also I noticed that some of these DT packages only run VB apps and noticed that some have been running for about 40-50hours nonstop. I know DTS packages do not error out on a VB exe. I fixed this and have taken out all the VB only exe and installed them on the NT scheduler. I'm hoping this fixes all the problems. But once again I believe our systems guys realized they dropped permissions on this user.
Thanks everyone
JMC
JMC
Viewing 3 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply