--Script to create a data file with custom header--
--To run file execute at command prompt sqlplus @
username/password@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.10.10.10)(PORT=1800))(CONNECT_DATA=(SERVICE_NAME=WhTVR)))
SET PAGESIZE 0
SET LINESIZE 20
SET term off
SET feed off
SET underline off
SPOOL C:\Users\userid\GIT\project\sql\JobID.dat
PROMPT JobID
select something from sometable;
SPOOL OFF
quit
--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
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);
}
}
}
}
}
}
}