What is the best approach to automate the running of SQL Queries in the Cloud database? Note the second part of the program is expected to send notifications that will include the changes completed by the query.
Discussion posts and replies are publicly visible
Can you share more of the business need/use case?
One generic way to do this is to
1. Create a PM that kicks off on a schedule
2. Calls a stored proc to execute queries and return a success/fail/etc
3. Have the pm properly notify
This keeps the queries and data out of memory and reduces footprint.
Hope that helps get you started
Hi Christine ,
Can you explain how to query the cloud dB on a everyday scheduled pm and get the results with pass or fail viewed by us , also can you suggest any automated tool for the purpose