MS SQL Server - Jobs and logins

Author

Jobs and logins

rgn

2006-12-06, 7:12 pm

Hello All,

One of our DBA’s left and he had owned some of the Jobs that he had setup. I
changed the owner of the Job to sa and deleted his account - "Portfolio\mpaul
" (Windows Authenticated) from the SQLServer Logins. This account is also
disabled from the Active Directory side.

Later, some of the Jobs that he owned (which is now owned by “sa”) keeps
failing. Since sa is the new owner of these jobs these should work - so I
thought. But these are failing.

Would anyone know how to sort this one out.

<<The job failed. The owner (Portfolio\mpaul) of job Agent history clean
up: distribution does not have server access.>>

Thanks,
rgn

Arnie Rowland

2006-12-06, 7:12 pm

It looks like you have a job that is calling another job -and the second one
is STILL owned by & #91;Portfolio\mpaul]
.

You need to transfer ownership of that second job [Agent history clean up:
distribution] to SA as well.

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf

"rgn" <rgn@discussions.microsoft.com> wrote in message
news:D9536A9C-C80C-4C56-AB82- ED531EEB464A@microso
ft.com...
> Hello All,
>
> One of our DBA's left and he had owned some of the Jobs that he had setup.
> I
> changed the owner of the Job to sa and deleted his account -
> "Portfolio\mpaul
> " (Windows Authenticated) from the SQLServer Logins. This account is also
> disabled from the Active Directory side.
>
> Later, some of the Jobs that he owned (which is now owned by "sa") keeps
> failing. Since sa is the new owner of these jobs these should work - so I
> thought. But these are failing.
>
> Would anyone know how to sort this one out.
>
> <<The job failed. The owner (Portfolio\mpaul) of job Agent history clean
> up: distribution does not have server access.>>
>
> Thanks,
> rgn
>

rgn

2006-12-06, 7:12 pm

I checked and the Jobs that are failing are not calling any other jobs.For
example this Job "Agent history clean up: distribution" is a replication job
and it was failing.

However, I changed the owner of the Job to the SQLServer Service account and
it is working now. But I still dont understand why these would fail when the
owner is "sa".

Thanks,
rgn

"Arnie Rowland" wrote:

> It looks like you have a job that is calling another job -and the second one
> is STILL owned by & #91;Portfolio\mpaul]
.
>
> You need to transfer ownership of that second job [Agent history clean up:
> distribution] to SA as well.
>
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
>
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
>
> You can't help someone get up a hill without getting a little closer to the
> top yourself.
> - H. Norman Schwarzkopf
>
>
> "rgn" <rgn@discussions.microsoft.com> wrote in message
> news:D9536A9C-C80C-4C56-AB82- ED531EEB464A@microso
ft.com...
>
>
>

Sponsored Links