I am building a job scheduling application - requirement is let user and admin monitor job running on web pages. User should only see his own jobs while admin is monitoring all jobs. My design is like this, when a job is triggered it is inserted into a table with structure below. As job goes on, its status is being updated accordingly in the same table.
CREATE TABLE JOB_STATUS {
ID INT,
USER_ID INT,
JOB_NAME VARCHAR,
STATUS INT
}
I had some basic knowledge of stomp endpoints so was thinking adopting this technique. While admin users could easily monitor the whole table, I have no idea how to build a stomp endpoint for a specific user to monitor its own job status. Any help is appreciated.