SQL Server Agent

SQL server agent is a software that is provided by the SQL server. Which helps to run any SQL job as a background process.

Steps to Run SQL Agent as follows -

• First Start the SQL Server Agent → Right-click on SQL Server Agent → Click on Start → Click on YES → YES.

• SQL Server Agent is started now and it will become a green sign.

• Create a new job → Right-click on jobs → New jobs.

• Give a name to the job

• Then add the Steps for the Jobs → Click on NEW.

• Give the name to the step → Select the database → Fire a SQL query → OK.

• Then add schedule means when you run the cube exactly for eg. 2min

• Give a name to the Schedule → Set all details → Click on OK.

• Start the job -

• The job will successfully RUN.

If you are new to SQL Server start with the following must-watch video: -