Job Error Messaging

  • jasoningram

    Ten Centuries

    Points: 1215

    I was wondering if anyone new of any tables in 7.0 used for job messaging that are not documented on the system table map.

  • Andy Warren

    SSC Guru

    Points: 119684

    I honestly haven't looked - are you looking for something in particular or just curious?

    Andy

  • jasoningram

    Ten Centuries

    Points: 1215

    The company I work for is creating a web based program that will report on job statuses. Basically, I'm trying to find any supporting tables that are used by EM for the job messaging. I searched through msdb and didn't find anything. My thinking is that most of the messaging comes from parsed fields in the sysjobhistory table and much of the others like "Success" and "Failure" are hardcoded in relation to fields like sysjobhistory.run_status. If they want it data driven, I'll probably create the look up tables within the project's database. I was just wanting to know if possibly these tables already existed somewhere.

Viewing 3 posts - 1 through 3 (of 3 total)

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