Job fails but no info on why

I'm running a maintenance plan and the job the does the integrity checks
fails, but in the job history log it gives no useful information as to why.
I can guess that there's something wrong with a relationship, index, or
missing data for the relationship, but this is a big db and it would be nice
if its going to fail, it could at least tell me why. For example, when
running a DTS, it there's an integrity issue, it will fail and tell me why.
Is there a stored procedure I can run that would list any issues that would
make this job fail? Any other advise?
Thanks.
moondaddy@.nospam.nospamIn Enterprise Manager, right click on the Maintenance plan (not the job) and
select 'Maintenance plan history' from the context menu.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"moondaddy" <moondaddy@.nospam.nospam> wrote in message
news:OsYC7GHuFHA.1252@.TK2MSFTNGP09.phx.gbl...
I'm running a maintenance plan and the job the does the integrity checks
fails, but in the job history log it gives no useful information as to why.
I can guess that there's something wrong with a relationship, index, or
missing data for the relationship, but this is a big db and it would be nice
if its going to fail, it could at least tell me why. For example, when
running a DTS, it there's an integrity issue, it will fail and tell me why.
Is there a stored procedure I can run that would list any issues that would
make this job fail? Any other advise?
Thanks.
moondaddy@.nospam.nospam|||Look on the job steps under the advanced tab, you are able to put a log
file directory / file name in here to monitor the activity performed by
the job process.
HTH, Jens Suessmeyer.|||Thanks.
moondaddy@.nospam.nospam
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1126623715.659637.295900@.z14g2000cwz.googlegroups.com...
> Look on the job steps under the advanced tab, you are able to put a log
> file directory / file name in here to monitor the activity performed by
> the job process.
>
> HTH, Jens Suessmeyer.
>|||Thanks. that gave me the clue I needed.
moondaddy@.nospam.nospam
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:u7OpsOHuFHA.1472@.TK2MSFTNGP15.phx.gbl...
> In Enterprise Manager, right click on the Maintenance plan (not the job)
> and
> select 'Maintenance plan history' from the context menu.
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "moondaddy" <moondaddy@.nospam.nospam> wrote in message
> news:OsYC7GHuFHA.1252@.TK2MSFTNGP09.phx.gbl...
> I'm running a maintenance plan and the job the does the integrity checks
> fails, but in the job history log it gives no useful information as to
> why.
> I can guess that there's something wrong with a relationship, index, or
> missing data for the relationship, but this is a big db and it would be
> nice
> if its going to fail, it could at least tell me why. For example, when
> running a DTS, it there's an integrity issue, it will fail and tell me
> why.
> Is there a stored procedure I can run that would list any issues that
> would
> make this job fail? Any other advise?
> Thanks.
> --
> moondaddy@.nospam.nospam
>
>