When working with SQL notebooks, I simply pass the SQL into the parameter value in the Databricks UI or in the job YAML:

dateadd(DAY, -1, '{{job.trigger.time.iso_date}}')