backup failed

hey
Sql Server 2005
I have Sql Server 2005 installed on a server. Each night the Sql Server
Agent start a job. This job fails. I wonder what causing this job to fail.
I've checked in Event viewer and it doesn't say more than "the job failed,
the job was invoked by Schedule 2 (backup_db), the last step to run was 1
(subplan)"
Any ideas how to find what causing this? Could I manually start this Sql
Server Agent job and then see what causing the job to failed?
This job have been running for months, it's only during the last 3 days it
started to fail
Basically I want to fix this job so it get completed successfully, so I
thought knowing what causing it to fail could help solving the problem...
but the main thing is that I want the job to complete successfully
any suggestions?Jeff
Please specify an output file in the step of the job (Steps--Edit--Advanced)
and see what is going on
"Jeff" <donot@.spam.me> wrote in message
news:uhhzFYIQIHA.4444@.TK2MSFTNGP02.phx.gbl...
> hey
> Sql Server 2005
> I have Sql Server 2005 installed on a server. Each night the Sql Server
> Agent start a job. This job fails. I wonder what causing this job to fail.
> I've checked in Event viewer and it doesn't say more than "the job failed,
> the job was invoked by Schedule 2 (backup_db), the last step to run was 1
> (subplan)"
> Any ideas how to find what causing this? Could I manually start this Sql
> Server Agent job and then see what causing the job to failed?
> This job have been running for months, it's only during the last 3 days it
> started to fail
> Basically I want to fix this job so it get completed successfully, so I
> thought knowing what causing it to fail could help solving the problem...
> but the main thing is that I want the job to complete successfully
> any suggestions?
>
>|||Hi Jeff,
First check the job history information. Right-click your job, View History
and click the + sign to see the job steps.
Also, check the SQL Server error log for related error messages.
Hope this helps,
Ben Nevarez
Senior Database Administrator
AIG SunAmerica
"Jeff" wrote:

> hey
> Sql Server 2005
> I have Sql Server 2005 installed on a server. Each night the Sql Server
> Agent start a job. This job fails. I wonder what causing this job to fail.
> I've checked in Event viewer and it doesn't say more than "the job failed,
> the job was invoked by Schedule 2 (backup_db), the last step to run was 1
> (subplan)"
> Any ideas how to find what causing this? Could I manually start this Sql
> Server Agent job and then see what causing the job to failed?
> This job have been running for months, it's only during the last 3 days it
> started to fail
> Basically I want to fix this job so it get completed successfully, so I
> thought knowing what causing it to fail could help solving the problem...
> but the main thing is that I want the job to complete successfully
> any suggestions?
>
>|||Hi Jeff
It sounds like you are not looking at the steps in the job history. Also
check out the SQL Server error log to see if anything has been written.
Which version of SQL Server are you running (SELECT @.@.VERSION)? It sounds
like this job is from a maintenance plan, you could try dropping the plan an
d
re-creating it.
John
"Jeff" wrote:

> hey
> Sql Server 2005
> I have Sql Server 2005 installed on a server. Each night the Sql Server
> Agent start a job. This job fails. I wonder what causing this job to fail.
> I've checked in Event viewer and it doesn't say more than "the job failed,
> the job was invoked by Schedule 2 (backup_db), the last step to run was 1
> (subplan)"
> Any ideas how to find what causing this? Could I manually start this Sql
> Server Agent job and then see what causing the job to failed?
> This job have been running for months, it's only during the last 3 days it
> started to fail
> Basically I want to fix this job so it get completed successfully, so I
> thought knowing what causing it to fail could help solving the problem...
> but the main thing is that I want the job to complete successfully
> any suggestions?
>
>|||select @.@.version returned
Microsoft SQL Server 2005 - 9.00.2050.00 (Intel X86) Feb 13 2007 23:02:48
Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows
NT 5.2 (Build 3790: Service Pack 2)
Step history (View History) said "Executed as user: PC1\SYSTEM. The package
execution failed. The step failed"
I didn't find any info in the Sql Server Error Logs about this|||select @.@.version returned
Microsoft SQL Server 2005 - 9.00.2050.00 (Intel X86) Feb 13 2007 23:02:48
Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows
NT 5.2 (Build 3790: Service Pack 2)
Step history (View History) said "Executed as user: PC1\SYSTEM. The package
execution failed. The step failed"
I didn't find any info in the Sql Server Error Logs about this
any suggestions?|||In the Sql Server Error Log I found this info (this info was added to the
log about 3 seconds after the Job started):
Message
Configuration option 'user options' changed from 0 to 0. Run the RECONFIGURE
statement to install.
***
This info was added to the Sql Server Error Log about the time the error
occured
CHECKDB for database 'test_db' finished without errors on 2007-12-17
04:00:04.470 (local time). This is an informational message only; no user
action is required.
any suggestions?|||In the Sql Server Error Log I found this info (this info was added to the
log about 3 seconds after the Job started):
Message
Configuration option 'user options' changed from 0 to 0. Run the RECONFIGURE
statement to install.
***
This info was added to the Sql Server Error Log about the time the error
occured
CHECKDB for database 'test_db' finished without errors on 2007-12-17
04:00:04.470 (local time). This is an informational message only; no user
action is required.
any suggestions?