Skip to Content
author's profile photo Former Member
Former Member

Source Connection checking & Job automation


I have a batch jobs which fetches data from source DB (oracle 10g) and to be executed after connection is released on daily basis.

Because of this dependency of connection release by source team DB team and manually checking connection and release then executing job manually is tedious task and because of this I have to work on weekends and on holidays too.

Now I want to automate the Job based on Below conditions so that I don't have to work on weekends and on holidays.

1> Checking IF connection is released or not

a. if Yes then Job should get started.

in the middle of job execution connection fluctuation may happen and job may get killed. In that case it should get started again.

b. If job is already running or has been executed successfully it should not get started.

c. If Connection is not released then redo step 1 may be at an interval of 1hours. (pts. a & b should be taken into consideration)


Sachin Gupta

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Nov 15, 2015 at 09:43 PM

    Schedule your job to run once a day. Build a loop into it. Catch the error. When the job succeeds, exit the loop. When it fails because the connection is not available, pause for one hour and retry.

    Add a comment
    10|10000 characters needed characters exceeded

    • Please familiarise yourself with The SCN Rules of Engagement

      • Avoid solicitations. Avoid marketing your company’s products and services. If you want people to know your affiliation with your company, put those details in your profile to make the information available to the community. Do not embed links to ads in your posts. The same applies to email solicitations and advertising. If you want someone to trust you enough to buy what you offer, share your expertise and they will seek you out. If you want people to contact you, you can choose to make your email visible in your profile, but we ask you not to post it elsewhere on the site.

      Contacting me directly forfeits the purpose of this forum. If you have a problem, chances are high somebody else runs into the same, sooner or later, and will be interested in the solution.

      If you really want private consultancy, you'll have to pay for it. I can send you my rates 😊.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.