Tasks After Restart

1. Execute the following script when you know that SQL Server was restarted:

DECLARE @command varchar(1000) SELECT @command = ' USE [?] IF (DB_NAME() LIKE %Novus) BEGIN

   EXECUTE [dbo].[usp_AsyncTaskMarkAsIdle] 
       EDI Scan Folder
       ,admin;
   EXECUTE [dbo].[usp_AsyncTaskMarkAsIdle] 
       Orders Invoicing
       ,admin;
   EXECUTE [dbo].[usp_AsyncTaskMarkAsIdle] 
       Invoice Printing
       ,admin;

END ' EXEC sp_MSforeachdb @command