Job Activity

USE msdb ;
GO

EXEC dbo.sp_help_jobactivity
{ [ @job_id = ] job_id | [ @job_name = ] 'job_name' }
[ , [ @session_id = ] session_id ]

GO

==========================================================

To check the status of the sql job depending on the id or job name or session id that you will provide. You should be a member of the sysadmin to be able to execute this stored procedure.

Done.