@Aubrey Price Thanks for reaching out. The SQL trigger requires change tracking to be enabled not with change data capture.
The SQL trigger uses SQL change tracking functionality to monitor a SQL table for changes and trigger a function when a row is created, updated, or deleted. Internally it used the same as azure function as documented here.
Therefor there is no configuration "How often do you want to check for items" as it uses the SQL change tracking.
Hi @Aubrey Price
I hope the answer helps. Feel free to get back to me if you need any assistance.
Please accept as "Yes" if the answer is helpful so that it can help others in the community. If you need any help/clarification/concerns/follow up questions, then please click on "Add Comment" on my answer and provide more details.