Hi,

I'm scheduling the report in Report Caster using the API. I have scheduled the report frequency as weekly once, along with the run day.
Though these values are properly updated in the Start Time, Start Date, Interval and Weekdays column of botsched table, the report gets delivered immediately.I think the issue is with the NextRunTime value. Currently I'm not manipulating the value for this column.
Should I need to use any API to update the value for that column , so that the report will get delivered only on the scheduled date ?

Thanks
Priya

This message has been edited. Last edited by: Kerry,

I would first take a look through the ReportCaster frontend to ensure that the correct date and start time are scheduled.
I'm pretty sure that date/time is stored in the ReportCaster repository in Universal time. So, if you want to run a job at 4:00PM Eastern time and that's what your sending and the time is currently 3:00PM Eastern, ReportCaster would look at the current time (3:00PM) as 8:00PM. Of course, this is past your 4:00PM scheduled time so the job would run immediate.
This is what would happen with ReportCaster Web Services which is built on top of the ReportCaster API.
Let me know how it goes.

Hi,
Thanks for the response. I compared the the schedule that I created manually in report caster which is scheduled to run on a weekly basis with the one that I created using the API.Under the schedule tab, there is an option "Enabled (Scheduled jobs runs at Specified time)". This when checked, the status of the schedule is Active in the BOTSCHED table. But for the one that I generated using the API, I see in the Report Caster front end that this option is not checked. Hence the staus goes to disabled after the report runs once immediately.
Pl let me know how I can enable this using the API.

Thanks
Priya

Hi Priya,
As I'm more familiar with ReportCaster Web Services, the ReportCaster API should have the same methods.

setActive(true); should accomplish what you need.

This is found in the main Schedule Class.

Let me know if this works.