October 8, 2001 at 3:40 pm
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.
October 8, 2001 at 4:09 pm
I honestly haven't looked - are you looking for something in particular or just curious?
Andy
October 9, 2001 at 10:39 am
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 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply