Post reply

saving output from a job that executes stored procs

  • June 10, 2004 at 4:22 pm

    #108334

    Hi,

    So I have an SQL Server Agent Job that kicks off some stored procs overnite.

    In the morning, I see from Ent Man if the job made it or not.

    Sometimes the job fails, and if I had the messages logged when the sp executes, I could tell where, and see if it was the code's fault.

    Is there any way to record the sp output messages for subsequent perusal?

    Thanks,

    Burt

  • June 10, 2004 at 4:55 pm

    #509980

    Why not just review sysjobhistory table via QA???



    Good Hunting!

    AJ Ahrens


    webmaster@kritter.net

  • June 10, 2004 at 5:01 pm

    #509982

    because I have no idea what that is?

    plz enlighten me, if u have the time.

    Thanks,

    burt

  • June 10, 2004 at 5:15 pm

    #509985

    I found the table, but it just sez the same thing - the job failed in step X.

    I need to see the "feedback" from the sp execution - so I can see msgs like : "Table Y doesn't exist" - for instance.

    Thanks again,

    Burt

  • June 11, 2004 at 9:06 am

    #510090

    You were absolutely right. The jobhistory table showed me everything I needed to see.

    Thanks again.

    Burt

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply