/soap:Envelope/soap:Body//*[2]//*[2]//*[2]/*/*/*/value[@*]
/soap:Envelope/soap:Body//*[2]//*[2]/*[2]/*[1]/*[1]/*[1]//@name
/soap:Envelope/soap:Body/*[ApplicationArea]/*[Sender]/*[ReferenceId]/ReferenceId/text()
	
	

--Script to get data for some period of time --
	 select sbj_no from sjb where sbj_no in(
        select sbj_no from prj.sbj_activity where CREATED_DATETIME > sysdate - interval '1' day and ASSIGN = 'N' 
    ) 
    and INIT_SERVICE_CODE IN ('name1', 'name2', 'name3')
    and sbj_no not in(select sbj_NO from prj.sbj_activity where ACTIVITY_CODE = 'actcode')
    order by created_datetime desc fetch first 100 row only

select count(isr_no) from C07_isr_activity where CXX_XXXXXX = 'XX' and CXX_START_DATETIME >= to_date('01 MAY 2021', 'DD MON YYYY')

using System;
using System.Configuration;
using System.IO;
using System.Net;
using System.Xml;
using System.Threading;

namespace OneMDS_CreateJob
{
    public class NewJob
    {
        static void Main(string[] args)
        {
            execJob(); Thread thr1 = new Thread(execJob); thr1.Start();
        }
        public static void execJob()
        {
            string sFileName;
            string[] aJobTypes = ConfigurationManager.AppSettings["JobTypes"].Split(',');
            string ServerName = ConfigurationManager.AppSettings["ServerName"];
            for (int r = 0; r < aJobTypes.Length; r++) {
                sFileName = aJobTypes[r] + ".xml";
                if (File.Exists(sFileName)){
                    Console.WriteLine("file name is " + sFileName);
                    HttpWebRequest Req = (HttpWebRequest)WebRequest.Create(@"http://" + ServerName + "/Cgi.Ssp.Web.Site/InboundJobService.asmx");
                    Req.ContentType = "text/xml;charset=\"utf-8\"";
                    Req.Accept = "text/xml";
                    Req.Method = "POST";
                    XmlDocument SOAPReqBody = new XmlDocument();
                    SOAPReqBody.Load(aJobTypes[r] + ".xml");
                    using (Stream stream = Req.GetRequestStream())
                    {
                        SOAPReqBody.Save(stream);
                    }
                    //Geting response from request  
                    using (WebResponse Serviceres = Req.GetResponse())
                    {
                        using (StreamReader rd = new StreamReader(Serviceres.GetResponseStream()))
                        {
                            var ServiceResult = rd.ReadToEnd();
                            XmlDocument xmlDoc = new XmlDocument();
                            xmlDoc.LoadXml(ServiceResult);
                            XmlNodeList jobId = xmlDoc.GetElementsByTagName("JobNumber");
                            Console.WriteLine("jobID " + jobId[0].InnerText);
                        }
                    }
                }
            }
        }
    }
}