how to get job in sap

IF EXISTS(SELECT * fromsysobjectsWHEREXtype= 'P' andName= 'Sp_check_job_status')BEGIN DROP PROCEDURESp_check_job_statusENDGOCREATE PROCEDURE [dbo].[Sp_check_job_status] as BEGIN SETNOCOUNT on SelectB.name, A.step_name, Msdb.dbo.agent_datetime (Run_date, Run_time) as 'Rundatetime', A.run_duration, Case whenA.run_status=0 Then 'Failed' whenA.run_status= 1 Then 'succeeded' whenA.run_status= 2 Then 'Retry' whenA.run_status= 3 Then '

| | Strchangs.trim (). Length () ==0) {response.ge Twriter (). Append ("Commodity manufacturers cannot be empty"); } else if (Strshoum = = NULL | | Strshoum.trim (). Length () ==0) {response.getwriter (). AP Pend ("Service life cannot be empty"); } else if (Strdizhi = = NULL | | Strdizhi.trim (). Length () ==0) {Response.getwrite R (). Append ("Factory address cannot be empty"); } else {Response.getwriter (). Append ("Product Name:" + strName); Res