是否可以在Sql server级别创建一个全局存储过程?

I created a query that takes a database backup at certain specified location. I want to use it as a stored procedure but this should act as a global stored procedure so that whenever this SP is called. Then database backup is taken.I created a query that takes a database backup