Run a function at a certain time every day?

Question

Using SQL Server, I want to know if it is possible to have a function I wrote run at a certain time every day. It will just perform a very small int insert into a table.

I'm not to sure how to go about this and I know how to use SQL Server generally.

See [create a job](https://learn.microsoft.com/en-us/sql/ssms/agent/create-a-job) in the documentation. — Dan Guzman, Dec 23 '18 at 14:41
I don't have the Agent on my Object Explorer? Do I need to download something? — , Dec 23 '18 at 14:51
SQL Server Express doesn't include Agent. You can use `Windows Scheduled Tasks` to schedule execution of SQL script using `sqlcmd`. — Andrey Nikolov, Dec 23 '18 at 14:57
I know now I have the Express version, what if I downloaded the Developer version? Will that come with the Agent? — , Dec 23 '18 at 15:28
duplicate of https://stackoverflow.com/q/5471080/125981 Express version duplicate https://stackoverflow.com/q/1675206/125981 — Mark Schultheiss, Dec 23 '18 at 15:34

score 0 · Answer 1 · answered Dec 23 '18 at 14:55

0

Yes it is possible with sql job please follow this documentation for more info https://learn.microsoft.com/en-us/sql/ssms/agent/create-a-transact-sql-job-step?view=sql-server-2017

-- creates a job step that uses Transact-SQL  
USE msdb;  
GO  
EXEC sp_add_jobstep  
    @job_name = N'Weekly Sales Data Backup',  
    @step_name = N'Set database to read only',  
    @subsystem = N'TSQL',  
    @command = N'ALTER DATABASE SALES SET READ_ONLY',   
    @retry_attempts = 5,  
    @retry_interval = 5 ;  
GO

answered Dec 23 '18 at 14:55

umesh99

215
1
11

Thanks! this has a lot of good information but now I am having another issue, I do not see the Agent in my Object Explorer. – Dec 23 '18 at 15:05
1

@OverFlowMars, it seems you are using SQL Express edition, which [doesn't include SQL Server Agent](https://learn.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2017). You could instead schedule a task via Windows Task scheduler that runs a T-SQL script using the SQLCMD command-line utility. – Dan Guzman Dec 23 '18 at 15:11
Ask them to add your login to msdb database 'sqlagentuserrole' . To add a user as a member of the 'sqlagentuserrole' , you can execute the following command: use msdb EXECUTE sp_addrolemember@rolename = 'sqlagentuserrole' ,@membername = 'username' – umesh99 Dec 23 '18 at 15:11

Run a function at a certain time every day?

1 Answers1