DTS data jobs that I used to be able to run with no problem in SQL7 are now refusing to run in 2K. Other jobs run when scheduled.
The really odd thing is that I can run these jobs by selecting them in local packages area in Enterprise Manager and selecting execute.
I figured it had to be something to do with the service accounts. I changed both to the same (and different than they had to start with) account. No change.
Anyone seen anything like this?
The really odd thing is that I can run these jobs by selecting them in local packages area in Enterprise Manager and selecting execute.
I figured it had to be something to do with the service accounts. I changed both to the same (and different than they had to start with) account. No change.
Anyone seen anything like this?