question

Kottn-9036 avatar image
0 Votes"
Kottn-9036 asked OlafHelper-2800 answered

SQL Server - Report Server Schedule

I am working in the SQL Server Enterprise (2019) - Power BI Report Server to create a shared schedule.

I can't seem to find the documentation on the Schedule Details within Site Settings. I found the schedule properties (general page) but that doesn't explain the various settings. For example, under the Month section, what is considered the "1st" week of the month? Is a week Sunday - Monday or any other date range or is it the first 7 days of a week?


I need to make a schedule to accommodate a monthly run every nth day. I have the query written and the step added but I want to create the schedule to run the job steps as little as possible first. I wasn't sure if the 1st week would capture the day I need every month or if I should just create the schedule to run every weekday every week.


sql-server-reporting-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ZoeHui-MSFT avatar image
1 Vote"
ZoeHui-MSFT answered

Hi @Kottn-9036,

I did some research online, there is indeed no official document to explain what's the "1st" week of the month mean.

I'd suggest that you may create the schedule to run every weekday every week to make sure the subscription work.

Regards,
Zoe


If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

What can I do if my transaction log is full?--- Hot issues November

How to convert Profiler trace into a SQL Server table -- Hot issues November


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

OlafHelper-2800 avatar image
1 Vote"
OlafHelper-2800 answered

A Report schedule is a SQL Server-Agent Job and here week is not defined as ISO week; the first week of a month starts with the first day of the month.

https://docs.microsoft.com/en-us/sql/ssms/agent/new-job-schedule-job-schedule-properties?view=sql-server-ver15

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.