|
|
Example: Periodically checking SQL table size Your company runs a manufacturing application that writes PLC data to an Oracle database. When the number of rows in the PLCMessages table exceeds 1 million, you would like to be notified via a cell phone text message. To do this, you will set up the Attention! AM SQL Agent to periodically send the total row count in the PLCMessages table to the Attention! AM server for processing. In this case, the row count will be sent every hour. Enter the following SQL Select statement in the Attention! AM SQL Agent:
Select Count(*)
|
![]() |
|
Privacy/Terms
Copyright © 2007 - All rights reserved. |