Tasks After Restart: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| (2 intermediate revisions by 2 users not shown) | |||
| 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: | ||
<pre>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</pre> | |||
<strong>Return to [[SQL Server]]</strong> | |||
Latest revision as of 18:29, 5 October 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
Return to SQL Server