In this article, I am going to introduce some advanced usages of the SQL Server Agent service in Microsoft SQL Server. In my previous article, Introduction to SQL Server Agent, I have discussed in detail how to use the service and the various components related to the service. To recap briefly, the SQL Server Agent is a job scheduler service within SQL Server and allows us to schedule T-SQL scripts, SSIS jobs, automate database backups and other tasks etc. In the last article, I have shown how to schedule a simple T-SQL script using the SQL Server Agent. This article will focus more on advanced concepts like scheduling a package in SSIS and processing an OLAP cube.
Read more »![Aveek Das](https://s33046.pcdn.co/wp-content/uploads/2021/01/AveekDas_80x80.jpg)
![Creating job step for OLAP Cube](https://s33046.pcdn.co/wp-content/uploads/2021/01/creating-job-step-for-olap-cube-624x567.png)