Start SQL Server Agent from SQL Server Management Studio

In this blog post we shall learn how to start a SQL Server Agent from SQL Server Management Studio. 

First connect to the SQL Instance using SSMS, then inside Object Explorer, collapse the tree view on the SQL Server. Right click on the SQL Server Agent and from the popup menu item, choose Start.

Do you like this site? Like our FB page @ Facebook.com\LearnSQLWithBru so that, you know when there is a new blog post.

–Bru Medishetty

What tools are used for SQL Server Report Server Administration?

Last weekend, a friend of mine and I, were discussing on SQL subject and SSRS in particular, asked me this question. Since he is yet to work on Administering SQL Server Reporting Services, he asked me some tips to get started and asked me to tell him the tools that are used by Admins while Administrating SQL Server Report Server. I thought to list those, that way the readers can be also benefited. 

Though explaining about how and where these are used is beyond my plan for this blog, I shall try to write about them in detail in future..

The list of tools goes like this (in no particular order)..

  • SQL Server Configuration Manager.
  • Reporting Services Configuration Manager.
  • SQL Server Management Studio.
  • Rsconfig Utility
  • RS Utility
  • Report Server Web Service URL
  • Report Manager
Do you like this site? Like our FB page @ Facebook.com\LearnSQLWithBru so that, you know when there is a new blog post.

– Bru Medishetty