Running Backup through Maintenance Plan

21 Nov 2006 2:57 PM

Andrew Harlan

I am receiving an Event 208 when running our autmated backup in Enterprise
Manager. The job use to run fine however possibly a change in password
caused this to stop working? The error states:

Event Type:    Warning
Event Source:    SQLSERVERAGENT
Event Category:    Job Engine
Event ID:    208
Date:        11/21/2006
Time:        8:45:00 AM
User:        N/A
Computer:    CROMWELL-DBPROD
Description:
SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan 'DB
Maintenance Plan1'' (0x8E8A44BEA81D964CAAF7E3F3338674D3) - Status: Failed -
Invoked on: 2006-11-21 08:45:00 - Message: The job failed. The owner () of
job DB Backup Job for DB Maintenance Plan 'DB Maintenance Plan1' does not
have server access.

How can I become owner of this job?

22 Nov 2006 1:47 AM

Sue Hoegemeier

Check the properties for the job named
DB Backup Job for DB Maintenance Plan 'DB Maintenance Plan1'
and change the owner to your login if you want to be the
owner.

-Sue

On Tue, 21 Nov 2006 06:57:02 -0800, Andrew Harlan
<AndrewHar***@discussions.microsoft.com> wrote:

Show quote

>I am receiving an Event 208 when running our autmated backup in Enterprise
>Manager. The job use to run fine however possibly a change in password
>caused this to stop working? The error states:
>
>Event Type:    Warning
>Event Source:    SQLSERVERAGENT
>Event Category:    Job Engine
>Event ID:    208
>Date:        11/21/2006
>Time:        8:45:00 AM
>User:        N/A
>Computer:    CROMWELL-DBPROD
>Description:
>SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan 'DB
>Maintenance Plan1'' (0x8E8A44BEA81D964CAAF7E3F3338674D3) - Status: Failed -
>Invoked on: 2006-11-21 08:45:00 - Message: The job failed. The owner () of
>job DB Backup Job for DB Maintenance Plan 'DB Maintenance Plan1' does not
>have server access.
>
>
>How can I become owner of this job?