July 2, 2004 at 2:09 pm
I can run any DTS job immediately just Fine but all of mny DTS jobs fail without a real error.
When I look in my event viewer, all it says is that the job failed on step 1.
Win 2k with SQL server 2k.
Ideas?
Thanks
July 3, 2004 at 12:58 pm
Generally, this is a permissions issue. Does the owner of the job have permissions to do everything the DTS package needs to do?
Derrick Leggett
Mean Old DBA
When life gives you a lemon, fire the DBA.
July 5, 2004 at 9:25 am
Check to see what account SQL Agent runs under. Most likely, it does not have permission to execute the job.
July 5, 2004 at 10:49 pm
This generally happens due to the permission problems and you can use the following SP to reassign the right to user for executing the DTS:
sp_reassign_dtspackageowner [@name =] 'name',
[@id =] 'id',
[@newloginname =] 'newloginname'
This may solve your problems.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply