31. 1. 2019
Na stejném serveru:
EXEC msdb.dbo.sp_start_job N'Nazev_jobu'
Job z linkovaného serveru:
SET @SQLCmd = '''EXEC msdb.dbo.sp_start_job N''''Nazev_jobu'''';'''
SET @SQLCmd2 = 'EXECUTE ('+ @SQLCmd +') AT [NAZEV_SERVERU]'
EXECUTE (@SQLCmd2)
Příklad
Spuštění jobu z Reporting Services na rozesílání Data check reportu jsou-li chybná data.
DECLARE @Cnt bigint = 0
SELECT @Cnt = COUNT(*) FROM DWH_MARTTech.dbo.DataCheck_DupliciteTransfersDocs;
IF ( @Cnt > 0 )
BEGIN
--- Run job which will generate Alert Report ---
EXEC msdb.dbo.sp_start_job N'Report_DupliciteTransfersDocs'
END;