Items -
1) For Each Loop
2) SQL Task (inside loop)
3) Task to once out of loop

Item #1 (For Loop properties)
	EvalExpression = @[User::jobValue]!=4 (4 means Idle job status)
	Note: Loop needs to be cycled by time interval say every minute

Item #2 (SQL Task)
Parameter Mapping: jobName (create variable to pass job name eg 'test')
ResultSet: Single row
	   Parameter Name = current_execution_status (column name from SP output)
	   Variable Name = User::jobValue (create one to hold current_execution_status value)
	   
Item #3
Execute whatever task from here


SQL TASK Statement:
	USE msdb ;
	GO

	EXEC dbo.sp_help_job
		@job_name = N'test'
	GO