SSRS - display SQL Agent job running status in ssrs report

Hi friends
if you want to display sql server agent job status as running then make the below code changes first in stored procedure of your sql stored procedure


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.'

Then come back to SSRS. Right click on properties of your tablix and find the field "No Rows Message". In this message enter SQL Agent job is running and hence no data is displayed