SQL Server Performance Forum – Threads Archive
Subscription stop firing
Since yesterday, new subscription will not fire. However old subscirpitons are still running as scheduled. Any ideas? Thanks.It turned out that the server’s time was a little bit ahead. When I set the reports to run in the next 2 minutes, the subscriptions were created. However the JOB in SQL server were disable because the time were already expired. Changed the server time and the problem was fixed. Thank you.
]]>