Restore old version of a BigQuery scheduled query

If your (accidentally) changed a Google BigQuery Scheduled Query and would like to go back to the old working version you can do following.

First: Find last correct running job:
Oben scheduled queries in your browser. Click on the name to get details and select a date at the next page. On the right site look for „Job“ and copy job id. Should looks like


Second: Open a console.
If not installed yet get BigQuery command line tools:
or you Google Cloud web console

If installed and configured you can call now

bq --format=prettyjson show -j <your_job_id>

Maybe pipe it into a file, find the query, copy query, removed „\n“ in a text editor and you have it.