Schedule at Month End

How do I create a schedule to run at month end?
I selected monthly, and tried to put 28,29,30,31 in calendar days, since
months vary, but I get this error "To create a schedule that runs on
multiple days, you must choose which days to use"
Any Ideas? I run monthly reports that create snapshots. I guess I
could run it at 12:01 on the 1st of the month, I but I used stored
procedures to calculate default dates and it really needs to run on the
last day of the month.
Thanks.Also, in addition to John's question, I have another question. How do I
name the report dynamically? If my report is for every month end, I want to
name it accordinly - JAN2005.csv, or something like that. In report Manager,
didn't see any option in generating filename.
Thanks
"John Geddes" wrote:
> How do I create a schedule to run at month end?
> I selected monthly, and tried to put 28,29,30,31 in calendar days, since
> months vary, but I get this error "To create a schedule that runs on
> multiple days, you must choose which days to use"
> Any Ideas? I run monthly reports that create snapshots. I guess I
> could run it at 12:01 on the 1st of the month, I but I used stored
> procedures to calculate default dates and it really needs to run on the
> last day of the month.
> Thanks.
>|||RS does not support this recurrence (last day of month). Your best bet is
to do what you suggested below. There is a way to get around this but it
has some side effects. After you create the schedule, find the
corresponding job in SQL Agent (doesn't matter what schedule you create
initially). Create the 12 schedules you will need in the sql agent job.
Now, RS will by default detect that the job is inconsistent with the RS
metadata and will update it. You can turn this off by updating the
IsSchedulingService to false in the RSReportServer.config file. Of course
by doing this RS will never check for consistency and it will be possible
for someone to update the schedules via SQL Agent (which is what you would
have done) and the recurrence will not correspond to what is being shown to
the user.
As for Vipul question, you can only accomplish this via Data Driven
subscriptions.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Vipul Shah" <VipulShah@.discussions.microsoft.com> wrote in message
news:9790438A-4833-4E9C-888A-47C43930CB28@.microsoft.com...
> Also, in addition to John's question, I have another question. How do I
> name the report dynamically? If my report is for every month end, I want
> to
> name it accordinly - JAN2005.csv, or something like that. In report
> Manager,
> didn't see any option in generating filename.
> Thanks
> "John Geddes" wrote:
>> How do I create a schedule to run at month end?
>> I selected monthly, and tried to put 28,29,30,31 in calendar days, since
>> months vary, but I get this error "To create a schedule that runs on
>> multiple days, you must choose which days to use"
>> Any Ideas? I run monthly reports that create snapshots. I guess I
>> could run it at 12:01 on the 1st of the month, I but I used stored
>> procedures to calculate default dates and it really needs to run on the
>> last day of the month.
>> Thanks.
>>