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

Return to SQL Server