Post reply

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

  • 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

  • November 10, 2016 at 4:29 am

    #1911589

    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.

    😎

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

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