How can I schedule a report in SharePoint to run on the last day of the month?

Question

I have several reports in SharePoint that are served by SQL Server Reporting Services in SharePoint Integrated mode. Some of these reports need to be automatically generated on the last day of the month. While SSRS itself has a "last day of month" option, SharePoint doesn't have this capability in its scheduling options.

What is the best way to add this capability? I don't mind writing code, or installing something, or enabling something I don't know about.

Answer 1

IMO, I would look into writing a Timer Job. I wrote one for a bi-weekly data import. I'm sure you could do an EOM report generation with it.

Answer 2

Search google for SPMonthlySchedule (timer job class in the SharePoint object model).

Answer 3

SPMonthlySchedule can only run on a specific date. Afaik you cannot configure it to run on the last day of the month.

I would create a timer job running daily, and doing the report if today is the last day of the month. Create a SPJobDefinition with a SPDailySchedule to achieve this.

Here is a howto.

if(DateTime.Now.Month != DateTime.Now.AddDays(1).Month)
{
 //Do report
}