There is a database on Sql Server 2012. We need to organize an automatic execution of a Sql query every month, please tell me how to do this. Thank you in advance.
|
1 answer
In SQL Server Management Studio -> SQL Server Agent -> Tasks.
Or EXEC sp_add_schedule and EXEC sp_attach_schedule .
An example is in MSDN - Task Planning .
andreycha
23.7k 3 39 77
Stack stack
8,662 9 56
- oneTo heap
sp_add_jobandsp_add_jobstep. - i-one
|