SQL Operations Studio Agent is visual way to see, edit and create SQL Server jobs and everybody was asking this feature when SQL Operations Studio appears.
To install this the agent follow the link https://docs.microsoft.com/en-us/sql/sql-operations-studio/sql-server-agent-extension?view=sql-server-2017.
Installing the agent
With the extension installed, right-click on the instance -> Manage to see the server jobs
But, not everything is working. I tried to edit a job step and didn’t work. For example, the Ola hallengren maintenace scripts after created wasn’t possible to change using the GUI differently than using SSMS.
Even trying to using the GUI to create a new step didn’t work and I changed using TSQL.
The script is available in my Git here to download. After changed the script I succeeded ran it.
With extensions we have more features available to work with SQL Operations Studio and is improving the utilization. Also you can create your own widget. In my tip on MSSQLTips.com I’m showing how to create it.
I recommend install SQL Server Agent, Profiler, Reports and certainly whoisactive