How to get the old stored procedure query

[dkumar1]

Hi,

I have one scheduled query and not running for long time and accidentally it got replaced by new design and no old code reference available anywhere. Any possibility to get the initial design from google cloud.

[mars124]

You can search in the job history of BigQuery of when you last remembered it ran like this:

Use “scheduled_query” as the search string then add property value for Created on.