I am confused about scheduling a DTS to run using Server Agent. Server agent service runs under local system account.
I have a DTS that when I open and choose Execute runs fine.
I logged on as sql admin and created a new DTS using my AD account. When is it scheduled to run I get back an error
The job failed. Unable to determine if the owner (AD\User) of job SW_to_DB has server access (reason: Could not obtain information about Windows NT group/user 'AD\User'. [SQLSTATE 42000] (Error 8198)).
so it sounds like the service cannot access the AD. Not sure what to do about that.
So I tried switching the job owner to a local account that I know has access to that DB. When I do that it does not run at all. I just get:
The job failed. The Job was invoked by Schedule 33 (SW_to_DB ). The last step to run was step 1 (SW_to_DB ).
I just want to schedule the DTS to run - but I am not sure where to chase this error.