How can I run a programmable query on Oracle database from Foglight at given time, let say once per day - it is a programmable script that would do some quires, some code etc. (see the attached script for simple example). That would be done once per day, for instance SOD in our business. There is no fail or success output, the output would have to be whatever the numbers query outputs - that would have to be saved somewhere or event sent on mail.
How would I go about this?? Thank you in advance!