Running Jobs under non-sysadmin credentials

Question

Hi,

Is it possible to make jobs visible to people other than the job owner?

Can jobs run under non-sysadmin account?

Thanks,

 Gulden

Answer 1

Gulden wrote:

Is it possible to make jobs visible to people other than the job owner? Can jobs run under non-sysadmin account?

Are you talking about packages saved to the database being visible to others?

As for running packages, as long as the account has the necessary db permissions (data reader on source, dbo on the target, etc), it should run fine.

Answer 2

We found out that users who need to see the packages should be entered in SQLAGENTOperator role. And job owner needs to be entered in DTSOperators Group.

Thanks.