MSBI Tutor

IF EXISTS( SELECT 1           FROM msdb . dbo . sysjobs J           JOIN msdb . dbo . sysjobactivity A               ON A . job_id = J . job_id           WHERE J . name = N'Your Job Name'           AND A . run_requested_date IS NOT NULL           AND A . stop_execution_date IS NULL          )     PRINT 'The job is running!' ELSE     PRINT 'The job is not running.'    

DECLARE @SQLStatement VARCHAR ( 200 ) DECLARE @jobName SYSNAME    DECLARE c1 CURSOR FOR    SELECT name FROM msdb . dbo . sysjobs_view WHERE name not in ( 'syspolicy_purge_history' , 'Agent history clean up: distribution' , 'Distribution clean up: distribution' , 'Expired subscription clean up' , 'INDSBLRHT0VR72-AdventureWorks2017-2' --Change the job name as per your environment , 'INDSBLRHT0VR72-AdventureWorks2017-Adven_Pub-2' --Change the job name as per your environment , 'INDSBLRHT0VR72-AdventureWorks2017-Adven_Pub-INDSBLRHT0VR72-5' --Change the job name as per your environment , 'Reinitialize subscriptions having data validation failures' , 'Replication agents checkup' , 'Replication monitoring refresher for distribution' )    OPEN c1    FETCH NEXT FROM c1 INTO @jobName      IF @@CURSOR_ROWS = 0      PRINT 'No Job found! Please re-c...