Solved

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

Posted on 2015-01-07
1
124 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 25

Accepted Solution

by:
Tomas Helgi Johannsson earned 500 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

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

Go is an acronym of golang, is a programming language developed Google in 2007. Go is a new language that is mostly in the C family, with significant input from Pascal/Modula/Oberon family. Hence Go arisen as low-level language with fast compilation…
In this post we will learn how to connect and configure Android Device (Smartphone etc.) with Android Studio. After that we will run a simple Hello World Program.
Viewers learn how to read error messages and identify possible mistakes that could cause hours of frustration. Coding is as much about debugging your code as it is about writing it. Define Error Message: Line Numbers: Type of Error: Break Down…
Viewers will learn about the different types of variables in Java and how to declare them. Decide the type of variable desired: Put the keyword corresponding to the type of variable in front of the variable name: Use the equal sign to assign a v…

806 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