search

cockroachdb / cockroach

CockroachDB — the cloud native, distributed SQL database designed for high availability, effortless scale, and control over data placement.
https://www.cockroachlabs.com
Other
30.16k stars 3.82k forks source link

jobs: add crdb_internal.scheduled_jobs built in #126110

Open msbutler opened 5 months ago

msbutler commented 5 months ago

While debugging scheduled jobs, it can be hard to unmarshal the ScheduleDetails and ExecutionArgs columns in the system.schedule_jobs print file in the debug zip. We ought to create a new crdb_internal.scheduled_jobs built in that unmarshals these fields for us and sticks them in the debug zip.

In the implementation, the ScheduleDetails proto should be flattened (i.e. one column for each field in the in the proto), as all jobs share these fields, while the ExecutionArgs should be one column, type json, as each schedule type has different execution args.

Jira issue: CRDB-39778

canhuynh1998 commented 4 months ago

Hey @msbutler I would like to give this issue a try, if there is nobody working on it?

msbutler commented 4 months ago

@canhuynh1998 thanks for the interest. we're going to handle this issue internally.