?
Solved

Create or update job(sequence of jobs) status in MySQL using Java

Posted on 2015-01-07
1
Medium Priority
?
149 Views
Last Modified: 2015-03-21
I have list of sequence  jobs written in java and i want to maintain their status in MySQL table like pending, completed with timestamp.
0
Comment
Question by:gaurav sharma
1 Comment
 
LVL 26

Accepted Solution

by:
Tomas Helgi Johannsson earned 2000 total points
ID: 40537781
Hi!
This is fairly simple.
You just create a table in MySQL with columns like
sequenceid, jobname, status and timestamp

Then do a simple insert into the table when the job is created/scheduled.
Then as the jobs are run then you simply update the depending rows with their status and current timestamp (when the insert/update is executed).

Regards,
       Tomas Helgi
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction Java can be integrated with native programs using an interface called JNI(Java Native Interface). Native programs are programs which can directly run on the processor. JNI is simply a naming and calling convention so that the JVM (Java…
Introduction This article is the second of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article covers the basic installation and configuration of the test automation tools used by…
Viewers will learn one way to get user input in Java. Introduce the Scanner object: Declare the variable that stores the user input: An example prompting the user for input: Methods you need to invoke in order to properly get  user input:
This tutorial will introduce the viewer to VisualVM for the Java platform application. This video explains an example program and covers the Overview, Monitor, and Heap Dump tabs.
Suggested Courses
Course of the Month15 days, 12 hours left to enroll

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question