Script to Check Sql Job Status

/***
When there is need to check for job is completed or not before triggering next process or job. we can use this script.

Setp_id is key column which provides details on Job Status.


**/

USE MSDB
SELECT name AS [Job Name]
         ,CONVERT(VARCHAR,DATEADD(S,(run_time/10000)*60*60 /* hours */  
          +((run_time - (run_time/10000) * 10000)/100) * 60 /* mins */  
          + (run_time - (run_time/100) * 100)  /* secs */
           ,CONVERT(DATETIME,RTRIM(run_date),113)),100) AS [Time Run]
           ,cast(run_date as varchar(10)) as Run_Date
         ,CASE WHEN SJH.run_status=0 THEN 'Failed'
                     WHEN SJH.run_status=1 THEN 'Succeeded'
                     WHEN SJH.run_status=2 THEN 'Retry'
                     WHEN SJH.run_status=3 THEN 'Cancelled'
               ELSE 'Unknown'  
          END [Job Outcome]
          ,step_id
          ,step_name
          ,run_status
FROM   sysjobhistory SJH  
JOIN   sysjobs SJ  
ON     SJH.job_id=sj.job_id  
WHERE  step_id=0  
AND    cast(run_date as varchar(10)) = CAST(getdate() as DATE)
AND name = 'Jobname'

ORDER BY name,run_date,run_time