Subscription stop firing | SQL Server Performance Forums

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.
]]>