yes this feature is available in the SQL analytics, you don't need a notebook here

you simply write the query and use the auto stop feature in the SQL warehouse .

you can refresh query there and set up for alerts to specific team or person