Schedule runs in advance (before specified time)

[mohammadjavaher]

Hi.

I have scheduled a report as follows:

I have added a card in report which displays date and time of last report refresh, Today I was looking at the report and found out that it has had refreshed today, before 8:15AM

As report is set to refresh every 3 hours, it's apparent that report is refreshed out of specified hours. I tried to investigate more and found related SQL Server Agent job. I was unable to open job's schedule, as SSMS gives me this error:

So, I scripted job to see what's inside. Thi is the schedule part:

This confirms that job should not run before 8:15AM. But there are more strange things here. active_start_time and active_end_time parameters have abnormal values compared to each other. End time comes before start time! Furthermore, why does SSMS give error on freq_subday_interval value? It is set to 180 and doesn't seem strange. Can someone help me on this behavior please?

Regards,

Mohamamd

[hackcrr]

hi, @mohammadjavaher 

The discrepancy between the scheduled and actual run times can be caused by SQL Server Agent misconfiguration or time zone issues.
Verify time zone:
You should ensure that the time zone is configured correctly on the Power BI Report Server and SQL Server.
Check if there are discrepancies in the time zone settings.
Since the error occurred in SSMS, try to modify the job schedule using T-SQL.
Correct the active_start_time and active_end_time values. These values ​​should be in the format of HHMMSS, for example, 081500 8:15 AM and 231500 11:15 PM.
Correct freq_subday_interval:
Ensure that the freq_subday_interval value is appropriate for the freq_subday_type. For an interval of 180 minutes (3 hours), the freq_subday_type should be set correctly.

The discrepancy between the scheduled and actual run times can be caused by SQL Server Agent misconfiguration or time zone issues.
Verify time zone:
You should ensure that the time zone is configured correctly on the Power BI Report Server and SQL Server.
Check if there are discrepancies in the time zone settings.
Since the error occurred in SSMS, try to modify the job schedule using T-SQL.
Correct the active_start_time and active_end_time values. These values ​​should be in the format of HHMMSS, for example, 081500 8:15 AM and 231500 11:15 PM.
Correct freq_subday_interval:
Ensure that the freq_subday_interval value is appropriate for the freq_subday_type. For an interval of 180 minutes (3 hours), the freq_subday_type should be set correctly.

After updating the job schedule, verify that it is running properly by monitoring the next scheduled run time.
You can also review the Power BI Report Server logs to identify any anomalies that may be affecting the report refresh schedule.

If this post helps, then please consider Accept it as the solution and kudos to this post to help the other members find it more quickly