Job in SQL Server

Question

How to use Job in SQL Server?

Jignesh Kumar · Answer

Hello Deepak, Please refer this thread, it will help you out, https://www.c-sharpcorner.com/UploadFile/raj1979/create-and-schedule-a-job-in-sql-server-2008/

Vishal Yelve · Answer

Hi Deepak, Do refer below link https://dotnettutorials.net/lesson/how-to-schedule-job-in-sql-server/

Rajeev Kumar · Answer

A SQL Job is a feature in Microsoft SQL Server that allows you to automate the execution of one or more SQL scripts or other tasks on a scheduled basis or in response to specific events. SQL Jobs are created using SQL Server Management Studio (SSMS) or Transact-SQL (T-SQL) scripts and can be scheduled to run at specific times or intervals, such as daily, weekly, or monthly. They can also be configured to run in response to events such as system startup, database backup completion, or the completion of another SQL job.

Satyapriya Nayak · Answer

http://msdn.microsoft.com/en-us/library/ms190268.aspx http://msdn.microsoft.com/en-us/library/ms135739%28v=sql.105%29.aspx http://www.sqlteam.com/article/scheduling-jobs-in-sql-server-express http://www.codeproject.com/Articles/431307/View-SQL-Server-Job-Status-using-SQL-Reporting-Ser http://www.quackit.com/sql_server/tutorial/sql_server_agent_jobs.cfm

Job in SQL Server

Answers (4)