Source Connection checking & Job automation

[Former Member]

Hi,

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)

Regards,

Sachin Gupta

[former_member187605 · Accepted solution]

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.

[Former Member · Accepted solution]

Thanks Dirk,

Is their any documents to go through in deep for BODS?

Also I would like to have your email-id to contact you if I get any issues related to BODS.(if you don't mind)

Is their any documents / website to go through explaining sample BODS projects from data extraction to final reporting (End - to - End)

using SAP BO ?

Regards,

Sachin

[former_member187605 · Accepted solution]

Please familiarise yourself with

• 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 .