Menu
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)?
836
Expand SQL Server Agent, expand Jobs, right-click the job that you want to schedule, and click Properties. Select the Schedules page, and then click Pick. Select the schedule that you want to attach, and then click OK.
You can use the administrative task scheduler to execute stored procedures at a specific time. You must first define a task for the stored procedure execution. Then, when the specified time or event occurs for the stored procedure to run, the administrative task scheduler calls the stored procedure.
job_id = j. job_id AND s. command LIKE '%procedurename%' ); Using this approach you could list all your store procedures (by name) and then find all jobs (or steps to be more specific) that contain these store procedures.
You will need to create a job using the SQL Server Agent.
76
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
