I am attempting to schedule a report to be compiled and sent on the first of every month.
I have found the procedures ad_schedule_proc that calls ns_schedule_proc, ns_schedule_daily, or ns_schedule_weekly.
None of these seem to fit perfectly, however I can see scheduling a script to run daily, at say 02.00.00, to look to see if it is the first of the month and if it is have the report run.
Is this a good way to accomplish this task? If so, do I need to keep track of the schedule id on my own that gets returned?
Is there a better alternative to this method?
Also, how do I get it to be automatically scheduled if and when the server is reset or restarted?
Thanks!