SQL Job "show history" truncated

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I have a job in the SQL Server "jobs" agent (the job scheduler) that runs a
DTS transaction. When I go to "view job history" and break it down to the
steps, the message box that shows for the main step seems to have the text of
the resulting messages truncated.

The problem I have is that some return code is getting set to indicate the
step fails. Since I can't see all of the messages, I can't figure out what
it thinks if failing.

Is there a way to get the complete text of the messages from a step in a SQL
Server job??
.

Relevant Pages

  • Re: ISAM Error SQL error -243
    ... is failing on the same table with the locking error. ... ARE there any chances that a SQL ... I know that there are no other processes running simultaneously to have ...
    (comp.databases.informix)
  • Re: Identity Column Question
    ... running V5R2 that uses embedded SQL for most of it's processing to ... The last sentence in the preceding paragraph leads me to think the program in question is a trigger program. ... Are you sure the duplicate key problem is happening when the program is writing to its target file, or could it be happening on one of the other files in the course of the copy? ... If none of the above is pertinent, I suggest you need to identify whatever it was that changed in the system at the point the program began failing. ...
    (comp.sys.ibm.as400.misc)
  • Re: Security Update for SQL Server 2005 Service Pack 2 (KB948109)
    ... I don't even know if I need this SQL Server and I have ... > account password, invalid user account, user account does not have ... To help you determine which service is failing to start,> view ...
    (microsoft.public.windowsupdate)
  • logging users against an update
    ... I don’t want to upsize to sql. ... I can then see how many records a user has updated Dailey? ... James ... Prev by Date: ...
    (microsoft.public.access.security)