Logging server errors

How or where does one get *meaningful* error logs from SQL Server/SQL Agent?
The logs generated on SQL Server are wholly inadequate, unless I am missing
something. A sample - trying to find out why my Integrity Checks job failed
last night:
DBCC CHECKDB (gIQInternetMaster, repair_fast) executed by NV\SQL_USR found 4
errors and repaired 0 errors.
So I look in the Application Event log for the machine:
SQL Server Scheduled Job 'Integrity Checks Job for DB Maintenance Plan 'DB
Maintenance Plan gIQInternetMaster'' (0x834A8604584AB24AB32FDA8DF8B39468) -
Status: Failed - Invoked on: 2004-09-30 00:00:01 - Message: The job failed.
The Job was invoked by Schedule 35 (Schedule 1). The last step to run was
step 1 (Step 1).
Is there something in that message I'm missing?Specify an output file in the jobstep. Note that this is in the job *step*.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Ron Hinds" <__NoSpam@.__NoSpamramac.com> wrote in message
news:emJg3EwpEHA.3980@.TK2MSFTNGP12.phx.gbl...
> How or where does one get *meaningful* error logs from SQL Server/SQL Agent?
> The logs generated on SQL Server are wholly inadequate, unless I am missing
> something. A sample - trying to find out why my Integrity Checks job failed
> last night:
> DBCC CHECKDB (gIQInternetMaster, repair_fast) executed by NV\SQL_USR found 4
> errors and repaired 0 errors.
> So I look in the Application Event log for the machine:
> SQL Server Scheduled Job 'Integrity Checks Job for DB Maintenance Plan 'DB
> Maintenance Plan gIQInternetMaster'' (0x834A8604584AB24AB32FDA8DF8B39468) -
> Status: Failed - Invoked on: 2004-09-30 00:00:01 - Message: The job failed.
> The Job was invoked by Schedule 35 (Schedule 1). The last step to run was
> step 1 (Step 1).
> Is there something in that message I'm missing?
>
>|||Thank you!
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23MEtBywpEHA.324@.TK2MSFTNGP11.phx.gbl...
> Specify an output file in the jobstep. Note that this is in the job
*step*.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Ron Hinds" <__NoSpam@.__NoSpamramac.com> wrote in message
> news:emJg3EwpEHA.3980@.TK2MSFTNGP12.phx.gbl...
> > How or where does one get *meaningful* error logs from SQL Server/SQL
Agent?
> > The logs generated on SQL Server are wholly inadequate, unless I am
missing
> > something. A sample - trying to find out why my Integrity Checks job
failed
> > last night:
> >
> > DBCC CHECKDB (gIQInternetMaster, repair_fast) executed by NV\SQL_USR
found 4
> > errors and repaired 0 errors.
> >
> > So I look in the Application Event log for the machine:
> >
> > SQL Server Scheduled Job 'Integrity Checks Job for DB Maintenance Plan
'DB
> > Maintenance Plan gIQInternetMaster''
(0x834A8604584AB24AB32FDA8DF8B39468) -
> > Status: Failed - Invoked on: 2004-09-30 00:00:01 - Message: The job
failed.
> > The Job was invoked by Schedule 35 (Schedule 1). The last step to run
was
> > step 1 (Step 1).
> >
> > Is there something in that message I'm missing?
> >
> >
> >
>