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 edit summary |
||
| Line 1: | Line 1: | ||
<strong>1.</strong> Execute the following script when you know that SQL Server was restarted: | <strong>1.</strong> Execute the following script when you know that SQL Server was restarted: | ||
Revision as of 15:15, 21 September 2023
1. Execute the following script when you know that SQL Server was restarted: