Permissions used for running Jobs

[Neil10]

I have a DTS package that exports data to a file, then run Win32 process pkzip to compress it to make it 4MB from 30MB so it can be emailed.
As this is to be run daily, I scheduled it, i.e. created a Job.
When running as a Job it fails in the pkzip section. The sqlservice account is not an NT system account for security reasons.

any ideas ?

TIA

Neil.

[rmiao]

What's sql agent service account? Did you test pkzip in dos prompt to see if it works? Any message in job history?

[Neil10]

the sql service account was a normal domain account.
In dos it would work fine, but in a job it failed. I have made the service account part of the local admin which has resolved the problem, although it is strange how the account works in dos, and direct in dts but not in a job, especially when I am logged in as that account for testing

[rmiao]

You can check things like who is job owner, what permission does job owner have, what's sql agent service account, etc.