How to create Alert if there in No New Data loaded into Table

Question

How to create Alert if there in No New Data loaded into Table

Sangeeth Raj

Hall of Fame

Points: 3541
More actions
November 10, 2016 at 3:02 am

#331859

Hi,
I have a table with date column and primary key column with auto increment, but few times we have been come across these tables not populated with new data due to Clients haven't send the data, Could some one tell me how do I create an alert to inform there is no new data loaded into tables.
Many Thanks

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

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

Eirikur Eiriksson SSC Guru Points: 182912 More actions · Answer 1

Sangeeth878787 (11/10/2016)
Hi,
I have a table with date column and primary key column with auto increment, but few times we have been come across these tables not populated with new data due to Clients haven't send the data, Could some one tell me how do I create an alert to inform there is no new data loaded into tables.
Many Thanks

Quick suggestion, create a procedure that counts rows with dates later than X and in none are found then it sends an email (i.e. dbmail). Then create a scheduled job that runs the procedure at the desired times.

😎