Monday, March 12, 2012

maint plan job hangs

I have a maint plan that backups up the t-logs of all the user databases,
while executing, the job runs nice and fast, but at the very end, when all
the backups are complete and you expect to see the job status to change from
'Executing' to 'Not Running', it doesn't.
the report is missing the last portion also, which should be :
"End of maintenance plan 'All_General' on 10/24/2004 3:00:30 PM
SQLMAINT.EXE Process Exit Code: 0 (Success)"
Anybody know why ?
Is there a way to set a more verbose output ?
"Johnny" <Johnny@.Knoxville.com> wrote in message
news:OBdqNwruEHA.3976@.TK2MSFTNGP09.phx.gbl...
> I have a maint plan that backups up the t-logs of all the user databases,
> while executing, the job runs nice and fast, but at the very end, when all
> the backups are complete and you expect to see the job status to change
from
> 'Executing' to 'Not Running', it doesn't.
Do you have it setup to email upon completion?
Is Email working?
This is the most common cause I've seen.

> the report is missing the last portion also, which should be :
> "End of maintenance plan 'All_General' on 10/24/2004 3:00:30 PM
> SQLMAINT.EXE Process Exit Code: 0 (Success)"
> Anybody know why ?
> Is there a way to set a more verbose output ?
>
>
|||no e-mail setup
"Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> wrote in message
news:kChfd.329041$bp1.38790@.twister.nyroc.rr.com.. .[vbcol=seagreen]
> "Johnny" <Johnny@.Knoxville.com> wrote in message
> news:OBdqNwruEHA.3976@.TK2MSFTNGP09.phx.gbl...
databases,[vbcol=seagreen]
all
> from
> Do you have it setup to email upon completion?
> Is Email working?
> This is the most common cause I've seen.
>
>

No comments:

Post a Comment