> Is it possible to write a sp to do daily schedule backup?

No, for two reasons:
- there is no timer/scheduler in Firebird
- you can't start a backup from a stored procedure.

You can use your OS's scheduler (AT, cron) and start a shell script
that calls the GBAK tool from the Firebird bin folder.

Best Regards

Stefan