• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 154
  • 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.
0
gaurav sharma
Asked:
gaurav sharma
1 Solution
 
Tomas Helgi JohannssonCommented:
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
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

Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

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