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*.[vbcol=seagreen]
> --
> 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...
Agent?[vbcol=seagreen]
missing[vbcol=seagreen]
failed[vbcol=seagreen]
found 4[vbcol=seagreen]
'DB[vbcol=seagreen]
(0x834A8604584AB24AB32FDA8DF8B39468) -[vbcol=seagreen]
failed.[vbcol=seagreen]
was
>