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...
> 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,
> Morgan
>|||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...
> > 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,
> >
> > Morgan
> >
> >
>|||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...
> 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...
> > > 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,
> > >
> > > Morgan
> > >
> > >
> >
> >
>|||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...
> > 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...
> > > > 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,
> > > >
> > > > Morgan
> > > >
> > > >
> > >
> > >
> >
> >
>|||A "hack" way is to create a script that does a "DIR" in the directory and delete 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...
> 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...
> > > 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...
> > > > > 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,
> > > > >
> > > > > Morgan
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>