April 6, 2010 at 1:15 am
Hi All
I need assistance
We have a telephone management system application that connects to a database & write entries made from a phone, sometimes data doesn’t get written so i need a way of checking that DB if entries were written in the last hour if not then it should send an alert. I can configure a database mail but the part i need most is the auditing of that DB
Thanks
It's better to fail while trying, rather than fail without trying!!!
April 6, 2010 at 2:09 am
What assistance you want ?
Vaibhav K Tiwari
To walk fast walk alone
To walk far walk together
April 6, 2010 at 2:14 am
Okay, maybe it's me i need to create a trigger that will audit a table where transactions are inserted when a phone call is made, some times the buffer of the telephone system doesnt send transactions to the table. I need to be alerted about that.
I hope i'm clear, Thanks
It's better to fail while trying, rather than fail without trying!!!
April 6, 2010 at 2:19 am
You want to know how to write trigger or what ?
Please be specific
Vaibhav K Tiwari
To walk fast walk alone
To walk far walk together
April 6, 2010 at 2:21 am
to write
It's better to fail while trying, rather than fail without trying!!!
April 6, 2010 at 6:14 am
It doesn't sound like a trigger is what you're looking for, especially since you're trying to check for a negative, rows that have not been added to the table. Since this is based on an hourly occurrence, why not use SQL Agent and simply write a query that checks for the expected rows and if they're not there it raises an error. It's pretty straight forward to have an Agent job send an email when an error occurs.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply