SQL Server automatically start routine

Asked Feb 05 '19 at 12:11

Active Feb 05 '19 at 12:11

Viewed 80 times

The title pretty much says it all: I want to automatically start a routine in MS SQL Server. More precisely, I have a routine (which deletes data from a table on a certain condition) that is supposed to run everyday, but I don't want to have an application having to trigger this routine.

Is there a functionality in SQL Server which supports this behaviour?

asked Feb 05 '19 at 12:11

MetaColon

2,895
3
16
38

3

Do you mean [SQL Server Agent](https://learn.microsoft.com/en-us/sql/ssms/agent/sql-server-agent?view=sql-server-2017)? – Thom A Feb 05 '19 at 12:13
4

It's called a [job](https://learn.microsoft.com/sql/ssms/agent/create-jobs). – Jeroen Mostert Feb 05 '19 at 12:14
1

Look at into the thread https://stackoverflow.com/questions/5471080/how-to-schedule-a-job-for-sql-query-to-run-daily – Suraj Kumar Feb 05 '19 at 12:20

SQL Server automatically start routine

0 Answers0