SQL Server - Report Server Schedule

Question

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.

Answer 1

Hi @Kottn ,

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

Answer 2

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://learn.microsoft.com/en-us/sql/ssms/agent/new-job-schedule-job-schedule-properties?view=sql-server-ver15