Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

jobs: add scheduled jobs to the DB Console #70725

Closed
adityamaru opened this issue Sep 24, 2021 · 2 comments
Closed

jobs: add scheduled jobs to the DB Console #70725

adityamaru opened this issue Sep 24, 2021 · 2 comments
Assignees
@benbardin
Labels
A-disaster-recovery C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) T-disaster-recovery
Projects
Disaster Recovery Backlog

Comments

@adityamaru
Copy link
Contributor

adityamaru commented Sep 24, 2021 •
edited by exalate-issue-sync bot

As more and more schedules are supported by CRDB it will be nice to have visibility into the schedules in a cluster from the debug console, instead of having to run SHOW SCHEDULES via the SQL shell. This will help diagnose errors that the schedule is running into quicker. We currently support scheduled backups, and scheduled auto stats compaction, but see a future where we might add scheduled exports and more.

While I leave the actual page design to owners of the cluster UI I believe it will look very similar to the current jobs page. SHOW SCHEDULES and SHOW CREATE SCHEDULES already have most of the information that we require and will power the endpoint from which the page will pull data. While the landing page will list an overview of all schedules in the cluster, clicking into a schedule can show you the exact sql query used to create that schedule. This is similar to how the jobs page works today.

Jira issue: CRDB-10190

Epic CRDB-14620
@adityamaru adityamaru added C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) A-disaster-recovery T-cluster-ui labels Sep 24, 2021
@adityamaru adityamaru added this to Triage in Disaster Recovery Backlog via automation Sep 24, 2021
@adityamaru adityamaru added this to Backlog in Cluster UI via automation Sep 24, 2021
@adityamaru
Copy link
Contributor Author

PR for adding a new scheduled jobs endpoint: #70680.

@livlobo livlobo moved this from Triage to Observability in Disaster Recovery Backlog Sep 27, 2021
@kevin-v-ngo kevin-v-ngo added this to Triage in Cluster Observability via automation Oct 6, 2021
@thtruo thtruo removed this from Backlog in Cluster UI Oct 6, 2021
@kevin-v-ngo kevin-v-ngo moved this from Triage to Backlog in Cluster Observability Oct 11, 2021
@shermanCRL
Copy link
Contributor

This might serve as a good project for @benbardin when ready to venture into some front-end. cc @duoclikebook @zaneteh-crl

@benbardin benbardin mentioned this issue Aug 24, 2022
Merged
maryliag added a commit to maryliag/cockroach that referenced this issue Aug 26, 2022
@maryliag
ui: combine jobs and schedules page
60204c2 
The new Schedules page is now grouped on the Jobs page.
This page only exists on DB Console and it not available
on CC Console.

Part of cockroachdb#70725

Release justification: low risk change
Release note (ui change): Combine the Jobs page and the new added
Schedules page into one. This is only available on DB Console.
@maryliag maryliag mentioned this issue Aug 26, 2022
Closed
maryliag added a commit to maryliag/cockroach that referenced this issue Aug 26, 2022
@maryliag
ui: combine jobs and schedules page
ea249bb 
The new Schedules page is now grouped on the Jobs page.
This page only exists on DB Console and it not available
on CC Console.

Part of cockroachdb#70725

Release justification: low risk change
Release note (ui change): Combine the Jobs page and the new added
Schedules page into one. This is only available on DB Console.
craig bot pushed a commit that referenced this issue Aug 26, 2022
@benbardin
Merge #86409
4471d8b 
86409: ui: Add page to view schedules in DB console. r=benbardin a=benbardin

*Summary*
Adds /schedules page in DB console. Structure is very similar to /jobs page. The new /schedules page provides a bit more observability into what schedules are running, and their various states.

Release note (ui change): Add page to view schedules in DB console.
Release justification: Low-risk - new, read-only page.
See also #70725

*Artifacts*
Loom link: https://www.loom.com/share/0fb4fee5859d4a46a3b6442892ae9ef6

<img width="1277" alt="Screen Shot 2022-08-18 at 2 23 40 PM" src="https://user-images.githubusercontent.com/261508/185491986-3063e9b5-af0f-41c5-bd69-1b7b6a9a871b.png">
<img width="1276" alt="Screen Shot 2022-08-18 at 2 23 14 PM" src="https://user-images.githubusercontent.com/261508/185491988-dba19a72-f1d6-4d74-9529-370d5012a0ad.png">
<img width="1260" alt="Screen Shot 2022-08-18 at 2 36 39 PM" src="https://user-images.githubusercontent.com/261508/185491985-3fd8293b-e6e1-4e6c-9f90-31b31b988677.png">
<img width="1257" alt="Screen Shot 2022-08-18 at 2 23 20 PM" src="https://user-images.githubusercontent.com/261508/185491987-fa5dc38e-1f8b-48b2-9c8f-39926db70e27.png">


Co-authored-by: Ben Bardin <bardin@cockroachlabs.com>
Disaster Recovery Backlog automation moved this from Observability to Done Aug 30, 2022
Cluster Observability automation moved this from Backlog to Done Aug 30, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@benbardin benbardin

Labels
A-disaster-recovery C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) T-disaster-recovery
Projects
Disaster Recovery Backlog
Done
Milestone
No milestone
Development

No branches or pull requests
4 participants
@benbardin @thtruo @adityamaru @shermanCRL