SQLTeam.com | Weblogs | Forums

Two identical agent jobs 1 works 1 doesn't

#1

Hello there, I have two identical agent jobs that run off the same proxy account.

One created under one account. Works fine,

The other is created under another account doesn't work

The package truncate a table, then pulls in data from an excel file.
Connection to the sql database is SQL Login, with saved password in the package.

They both run under the same proxy account, i cannot understand why one would work and the other doesn't.

BUT. The job that doesn't work is created by the same account that is under the Proxy account

Does anyone have any suggestions on what else i could check please.

Regards

Rob

#2

what error message do you get?

#3

You have 2 separate items to consider:

  1. Job Owner - is the account that the job is owned by a sysadmin?
  2. Job Step - Run As...does the proxy account have the necessary permissions?

When the owner of the job is a sysadmin account - the job will be run in the context of the agent service account and the job step will be run in the context of the proxy account.

When the owner of the job is a non-sysadmin account - the job will be run in the context of the non-sysadmin account and the job step will be run in the context of the proxy account.

Then - you can determine where the error is occurring and why. The job that is failing is most likely failing because the owner of the job (proxy account) does not have the necessary rights/permissions to execute the SSIS package.