sql - Automating the scheduletable of jobs -

-

There was a table where we had the names of the nomenclature and the time of tahara was stored there, I will run a script which Runs and checks if any

Actually I want to create a script which will call my SQL query

For example, the name of the table is SCHEDULE. .column JOBNAME and COLUMN SCHEDULE_TIME to move and

rhythm Believing that the work was going on and when it was called "Joblo" and the actual time of every job is stored on that table in the column called "ACTUAL_TIME", then you will run something like:

It will show the jobs that were set, or the job which was set to last 10 or more minutes, but which have not yet started (in the latter case, the third column will be zero) < / P> 

  f S.jobname, S.schedule_time, s.jobname = l.jobname, where l.actual_time & gt; S.schedule_time or (l.actual_time is zero and (sysdate - s.schedule_time) * 24 * 60> = 10)

Comments

Post a Comment

Popular posts from this blog

java - org.apache.http.ProtocolException: Target host is not specified -

-
I have written a simple httprequest / response code and I am getting this error below: I used to type in my classpath httpclient, httpcore, common -Codecs and general logging. I am very new to Java and I do not know what's going on here. Please help me. code: import org.apache.http.client.HttpClient; Import org.apache.http.client.methods.HttpGet; Import org.apache.http.HttpResponse; Import org.apache.http.impl.client.HttpClientBuilder; Import org.apache.http.Header; Import org.apache.http.HttpHeaders; Public class UnshorteningUrl {public static zero main (string [] args throws exception {HttpGet request = zero; HTTP Client Client = HTTP ClientBuilder.credit (). Build (); Try {Request = New HTTP Gate ("trib.me/1lBFzSi"); HttpResponse httpResponse = client.execute (request); Header [] header = httpResponse.getHeaders (HttpHeaders.LOCATION); // Preconditions.checkState (headers.length == 1); String new url = header [0] .getValue (); System.out.println ("new url...
Read more

c# - Create dynamic LINQ query expression at runtime which translates into a parameterized SQL query for nullable types -

-
This question is related to my I want to make my custom expression for IQueryable in a nutshell. To achieve this goal, I wrote the next code. Public stable IQueryable & lt; T & gt; Filter Aquales & lt; T, TLL & gt; (This IQueryable & lt; T & gt; qSource, expression & lt; Func & lt; t; TLL; Field, TV value) {var fieldFilter = ExpressionClosureFactory.GetField (value); Var constraint = expression. Aqual (field. Body, field filter); Apply Return (qSource, Obstacle, Zone. Parameter); } Private Stable IQueryable & lt; T & gt; Apply & lt; T & gt; (IQueryable & lt; T & gt; qSource, Expression Barrier, ReadOnlyCollection & lt; Parameter Exposure & gt; Parameter) {var predicateFrom = Expression Lambda & lt; Func & lt; T, bool & gt; & Gt; (Hurdle, parameter); Return qSource.Where (predicateFrom); } Public Speaking Expression Clausfactree {Public Status Member Expert Gatefield & lt; TVLUE & gt; (TV va...
Read more

cmake - cpack generates RPMs with %files entries that conflict with the RPM spec. How to fix? -

-
Recently, I need to make sure that using our software by using cpack RHEL 7 and it can be packaged for free reconstruction (such as CentOS 7). Despite this, I have had a problem which was not present for RHEL 6.x and its free rebuilding: RPM, which has its % files cpack System entries such as the following are generated: % dir% attr (0755, root, root) "/"% dir% attr (0755, root, root) "/ usr"% Dir% attr (0755, root, root) "/ usr / bin"% dir% attr (0755, root, root) "/ usr / share"% dir% attr (0755, root, root) "/ usr / share / Applications "% dir% atr (0755, root, root)" / usr / share / doc "% dir% attr (0755, root, root)" / usr / share / icons "% di "/ Usr / share / icons / hicolor" / dir / hicolor "/ usr / users / share / icon / hicolor / scalable"% dir% attr (0755, root, root) Enter the% dir% plus (0755, root, root) "/ scalable / app" code which should not be declared by ...
Read more