wrote:
> We run a scheduled job with Owner: SvcExePUser. In the log after the job
> completes, it appears to run as US\svcClus as listed below:
>
> Executed as user: US\svcClus. ...OnStart: DTSStep_DTSExecutePackageTask_1
>
> One of our scheduled jobs keeps failing because the directory it is
> transmiting the data to is not part of the svcCLus group and our Security
> group does not want to make it a part of that group.
>
> Is it possible to have the job run not as US\svcClus, but the ID it was run
> under which was SvcExePUser ?

"jhofmeyr@googlemail.com" wrote:

> On Sep 28, 1:04 pm, rmcompute <rmcomp...@discussions.microsoft.com>
> wrote:
> > We run a scheduled job with Owner: SvcExePUser. In the log after the job
> > completes, it appears to run as US\svcClus as listed below:
> >
> > Executed as user: US\svcClus. ...OnStart: DTSStep_DTSExecutePackageTask_1
> >
> > One of our scheduled jobs keeps failing because the directory it is
> > transmiting the data to is not part of the svcCLus group and our Security
> > group does not want to make it a part of that group.
> >
> > Is it possible to have the job run not as US\svcClus, but the ID it was run
> > under which was SvcExePUser ?
>
> Hi rmcompute,
>
> If I remember correctly when you execute a job in SQL Server it
> executes using the SQL Agent service account by default. It is
> possible to set the user to use for each step of the job (when
> creating the step, click the Advanced tab - there should be a Run As
> parameter), but I'm not sure if this can be done at the Job level.
> Purhapse you should re-post this in one of the SQL Server admin
> forums.
>
> Good luck.
> J
>
>
>
>