• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 151
  • Last Modified:

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

I have list of sequence  jobs written in java and i want to maintain their status in MySQL table like pending, completed with timestamp.
gaurav sharma
gaurav sharma
1 Solution
Tomas Helgi JohannssonCommented:
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).

       Tomas Helgi
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now