Can someone explain how pricing works on scheduled triggers? and how costly it is? I want to run every 5 minutes just 1 request to forge SQL storage to check the state and if needed to run large computation(it will not be done often). How costly it will be just for status check request in every 5 minutes?
The cost to run a scheduled trigger is based on the duration and memory of the function you execute on the schedule plus whatever SQL costs are incurred from your query. It sounds like your SQL query is simple, and the function will be quick most of the time with an occasional large computation.
Pricing details are available on our cost estimator: Forge Cost Estimator
In your example, let’s say your scheduled trigger runs every 5 minutes, has 512MB memory, and 90% of time it only takes 2 seconds to check that no work is required, and the other 10% of the time it takes 1 hour to perform the large computation.
In a 24 hour period, it would run the ‘quick’ check 259 times, and the large computation 29 times. This would give you:
- 259 x 2 seconds x 0.5GB RAM = 259 GB-seconds per day
- 29 x 3600 seconds x 0.5GB RAM = 52,200 GB-seconds per day
52,459 GB-seconds per day, x ~30 to give you 1,573,770 GB-seconds per month. This comes to $36.84 USD per month, assuming that it also consumes the 100,000 GB-seconds of free usage each month.
To that you would also add the cost of your SQL request (charged based on total storage, number of request, and request processing time) and any log messages you want to generated (charged based on GBs of log messages generated).