https://docs.snowflake.com/en/sql-reference/functions/system_trigger_listing_refresh

show listings;

select system$trigger_listing_refresh('LISTING','LISTING_NAME');