Tasks After Restart: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 19: | Line 19: | ||
EXEC sp_MSforeachdb @command</pre> | EXEC sp_MSforeachdb @command</pre> | ||
<strong>Return to [[SQL Server]]</strong> | <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