Aliendan,
I just did some testing with SolarWinds SEUM product (www.solarwinds.com/.../application-monitoring-software.aspx) to simulate the manual running of scheduled published report, and it was successful.
I had SEUM simulate the following:
Each time the simulator ran, the report in the C:\Program Files\SolarWinds\Storage Manager Server\webapps\ROOT\publish directory was updated with the latest data.
I hope this helps!
The report schedules are stored in the database table 'reporter_schedules'. In this table, there is a field 'scheduleTime' that is a millisecond time stamp value of when the schedule will run next.
To have the schedule run every 15 minutes, you will need to update the 'reporter_schedules' table every 15 minutes, and set the 'scheduleTime' field for 15 minutes in the future. Be sure to only update the table for the 'scheduleId' field of the schedule you are interested in.
You can do this with the Windows Task Scheduler to execute a sql script. Or, you can use the event scheduler within MySQL. If you do that, be sure to alter your my.ini file for mysql to enable the event scheduler.
Thanks,
Nathan
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.