SQL 2K Problem with DTS and Job Scheduling 1

[hughed00]

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?

 

[tlbroadbent]

Have you read the Knowledgebase article Q269074, INF: How to Run a DTS Package as a Scheduled Job?

URL:

http://support.microsoft.com/support/kb/articles/Q269/0/74.ASP

It may provide some help. Terry

http://members.home.net/tlbroadbent/index.htm

 

[hughed00]

I figurede it had to do with permissions, never really figured out which one was doing it, but went back to a SQL service account which I used to use for both SQL and jobs, everything works now.