How to get bigquery's scheduled queries execution log programmatically?

Question

I would like to get execution log of scheduled queries in bigquery programmatically. It is very much possible using web UI but if there any way using Standard SQL or any API which is providing that log would be fine.

Thanks in advance

Answer 1

Try querying the INFORMATION_SCHEMA.JOBS_BY_PROJECT view.

For example:

select *
FROM `elzagales`.`region-us`.INFORMATION_SCHEMA.JOBS_BY_PROJECT
where
  job_id like "%scheduled_query%"
  and priority = "BATCH"

you may need to adjust your job_id if you provide a custom job_id to your scheduled queries.