sql - How to schedule a stored procedure?

Question

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

How do I schedule a stored procedure in Sql Server 2005 that it runs once at the start of every month (and on database startup)?

See Question&Answers more detail:os

与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…

339 views

1 Answer

深蓝 · Answer 1 · 2021-10-23T17:48:37+0000

answered Oct 24, 2021 by 深蓝 (71.8m points)

You will need to create a job using the SQL Server Agent.

与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…