Tasks After Restart: Difference between revisions
Jump to navigation
Jump to search
(Created page with "<strong>1.</strong> 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''; EN...") |
(No difference)
|
Revision as of 15:03, 21 September 2023
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