September 15, 2010 at 1:23 am
Hi Guys,
I'm in the process of building a small php front end to our sheduled tasks so that our IT Service Desk can see if a regular job fails (without using database mail or giving them ssms)
so that means I need to get any stored proc outputs and messages stored in a database table to make available to people to look at later via this front end...
there must be some way to do it that already built into SQL Server - any advice?
Thanks,
Ben
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------
September 15, 2010 at 6:20 am
when you say any regular job fails, are you talking just about SQL Agent jobs? If they are calling stored procs and the stored procs fail, then they will also fail.
For better, quicker answers, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 15, 2010 at 7:02 am
Hi Mike,
in this context 'Fail' can mean many things - either the sproc did not complete or if it is say a procedure that searches our database for known issues (like a customer's surname gets nulled etc) if the search returns new cases of this issue - even though the proc completed normally it would report a 'failure' or 'warning' for our service desk to look into.
I need to get info like '(17 rows affected)' and 'cannot insert duplicate key into table tblBlahBlah'
plus a true/false for did the did the sproc complete normally.
Any ideas?
Thanks
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply