a Monitor service for SQL table
I'm looking for the a simple-quick-easy solution to monitor a SQL table thought Ensemble.
I have a process that update a DataBase ,a scheduled task that runs every night (Not Ensemble)
In the end it updates a table (replica_status) with a new recored with two fileds: Id, DateTime
I looked around the community but didn't find an answerd case.
I'm thinking on a Task that will run a sql outboud adapter BO that checks that table and send a alert if no new record was created yesterday
is this the right approach or is there's a better solution?