Schedule a job using tsql

Question

Schedule a job using tsql make backup on every monday at 12:00 pm

Bhuvanesh Mohankumar · Answer

Hope this may be helpful,
USE msdb ;
GO
EXEC dbo.sp_add_job
@job_name = N'Weekly Sales Data Backup' ;
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
EXEC dbo.sp_add_schedule
@schedule_name = N'RunOnce',
@freq_type = 1,
@active_start_time = 233000 ;
USE msdb ;
GO
EXEC sp_attach_schedule
@job_name = N'Weekly Sales Data Backup',
@schedule_name = N'RunOnce';
GO
EXEC dbo.sp_add_jobserver
@job_name = N'Weekly Sales Data Backup';
GO Mark as answer, if helpful.

Shakti Singh Dulawat · Answer

sp_add_schedule (Transact-SQL) https://msdn.microsoft.com/en-us/library/ms187320.aspx

Jayesh shukla · Answer

I want Tsql fro scheduling not using gui

Shakti Singh Dulawat · Answer

Please find MSDN https://msdn.microsoft.com/en-in/library/ms191439.aspx
We have one article available on your website http://www.c-sharpcorner.com/UploadFile/raj1979/create-and-schedule-a-job-in-sql-server-2008/