SELECT
	s.step_id
,	s.on_success_action
,	s.on_success_step_id
,	s.on_fail_action
,	s.on_fail_step_id
FROM
	msdb..sysjobs j
JOIN
	msdb..sysjobsteps s
ON
	j.job_id = s.job_id
WHERE
	j.name = '<Job_Name>'
	
SELECT TOP (15)
	h.step_id
,	h.run_date
,	h.run_time
,	h.run_status
FROM
	msdb..sysjobs j
JOIN
	msdb..sysjobhistory h
ON
	j.job_id = h.job_id
WHERE
	j.name = '<Job_Name>'
ORDER BY
	run_date DESC
,	run_time DESC