Maintenance Plan "fails"..

Thanks in advance for any insight.
On occasion, one of my schedule jobs will "fail", in that all tasks
complete, but it still reports failure. Strangely enough, nothing is written
to SQL Server log, but I do have the following entry in the Event Viewer:
"SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan 'Non-Great
Plains Daily Backup'' (0x01BF5D1C32E9FF418D67E99A77A4A014) - Status:
Failed - Invoked on: 2004-06-08 20:00:00 - Message: The job failed. The Job
was invoked by Schedule 35 (Schedule 1). The last step to run was step 1
(Step 1)."
Any ideas on how to troubleshoot this?
Thanks,
MorganAny messages in the report file? (Did you specify a report file, btw?)
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Morgan" <abcd@.senditon.com> wrote in message news:eiY8NRjTEHA.1284@.TK2MSFTNGP10.phx.gbl...[
vbcol=seagreen]
> Thanks in advance for any insight.
> On occasion, one of my schedule jobs will "fail", in that all tasks
> complete, but it still reports failure. Strangely enough, nothing is writt
en
> to SQL Server log, but I do have the following entry in the Event Viewer:
> "SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan 'Non-Grea
t
> Plains Daily Backup'' (0x01BF5D1C32E9FF418D67E99A77A4A014) - Status:
> Failed - Invoked on: 2004-06-08 20:00:00 - Message: The job failed. The Jo
b
> was invoked by Schedule 35 (Schedule 1). The last step to run was step 1
> (Step 1)."
> Any ideas on how to troubleshoot this?
>
> Thanks,
> Morgan
>[/vbcol]|||Hi Tibor,
The only thing in the report file is that it was unable to delete one of the
database backups. Other than that, all of the steps completed. Would that
cause the job to think it failed?
Thanks,
Morgan
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:ubeNMltTEHA.2544@.TK2MSFTNGP10.phx.gbl...
> Any messages in the report file? (Did you specify a report file, btw?)
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Morgan" <abcd@.senditon.com> wrote in message
news:eiY8NRjTEHA.1284@.TK2MSFTNGP10.phx.gbl...
written[vbcol=seagreen]
Viewer:[vbcol=seagreen]
'Non-Great[vbcol=seagreen]
Job[vbcol=seagreen]
>|||If I wrote the code, yes a failed deletion of a backup file would cause the
job to fail.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Morgan" <abcd@.senditon.com> wrote in message news:eVp7v$uTEHA.3988@.tk2msftngp13.phx.gbl...[
vbcol=seagreen]
> Hi Tibor,
> The only thing in the report file is that it was unable to delete one of t
he
> database backups. Other than that, all of the steps completed. Would that
> cause the job to think it failed?
> Thanks,
> Morgan
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote i
n
> message news:ubeNMltTEHA.2544@.TK2MSFTNGP10.phx.gbl...
> news:eiY8NRjTEHA.1284@.TK2MSFTNGP10.phx.gbl...
> written
> Viewer:
> 'Non-Great
> Job
>[/vbcol]|||Ha! I hear ya. Would be nice if each piece of a maintenance plan could be a
seperate job, that way if deleting a previous days backup failed it wouldn't
look like the databases didn't get backed up since that would be a seperate
task with its own status.
Thanks,
Morgan
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:e3i9JIvTEHA.644@.tk2msftngp13.phx.gbl...
> If I wrote the code, yes a failed deletion of a backup file would cause
the job to fail.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Morgan" <abcd@.senditon.com> wrote in message
news:eVp7v$uTEHA.3988@.tk2msftngp13.phx.gbl...
the[vbcol=seagreen]
that[vbcol=seagreen]
in[vbcol=seagreen]
The[vbcol=seagreen]
step 1[vbcol=seagreen]
>|||A "hack" way is to create a script that does a "DIR" in the directory and de
lete old files. This can be done
using ActiveScript, TSQL of whatever is your preference...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Morgan" <abcd@.senditon.com> wrote in message news:OPwIwByTEHA.3480@.TK2MSFTNGP11.phx.gbl...[
vbcol=seagreen]
> Ha! I hear ya. Would be nice if each piece of a maintenance plan could be
a
> seperate job, that way if deleting a previous days backup failed it wouldn
't
> look like the databases didn't get backed up since that would be a seperat
e
> task with its own status.
> Thanks,
> Morgan
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote i
n
> message news:e3i9JIvTEHA.644@.tk2msftngp13.phx.gbl...
> the job to fail.
> news:eVp7v$uTEHA.3988@.tk2msftngp13.phx.gbl...
> the
> that
> in
> The
> step 1
>[/vbcol]