Feature Request - Add SQL Server Agent Section about azuredatastudio HOT 19 CLOSED

@bush3102 SQL Agent support is on our GA roadmap, though we still need to work through the details of what this will look like exactly.

from azuredatastudio.

Hey @justPaulo, it's not listed in the object explorer. Just right click on a server and press Manage. It's listed next to Home as a tab.

from azuredatastudio.

Spotted at last :-), thanks @SebastianPfliegel.

from azuredatastudio.

hi @kburtram my newly installed sql server agent extension keeps spinning and not listing any jobs. I am running on my own SQL Server created on my desktop, so I should have the administrator access. Can you help?

from azuredatastudio.

I agree with this much needed feature. I downloaded the tool today and have been playing with the options. I really like the customization we can do within the tool. To my disappointment I found no SQL agent present. Please add this feature.

from azuredatastudio.

Good to hear this is on the roadmap. I'm really enjoying SOS, but without SQL Sever Agent functionality I will have to stick with SSMS.

from azuredatastudio.

@kburtram I apologize for the crudeness of the screenshot, but I am so excited that it is on the GA roadmap. Please reach out to me (email or Twitter: @jeremyfegenbush) if you need any help testing.

from azuredatastudio.

@bush3102 Thanks for offering your help! Certainly we will reach out to you very soon. We want to prioritize the features and set iterative implementation and release.

from azuredatastudio.

We are working on the SQL Agent extension, and we would appreciate community feedback on the initial UX designs. Please provide your feedback in this issue: #750

from azuredatastudio.

Any ETA for SQL Server Agent on SQL Ops Studio ?

from azuredatastudio.

@justPaulo, try the new sqlops version, it features extensions. The SQL agent extension is already available.

from azuredatastudio.

@SebastianPfliegel I'm already using latest version available (Version 0.26.7) on Linux. No extensions present though. How can I retrieve and install such extension?
Thanks

from azuredatastudio.

That's not the current release. This one is: https://github.com/Microsoft/sqlopsstudio/releases/tag/0.27.4

The page also mentions on how to obtain the extension.

from azuredatastudio.

Link resolves to March Public Preview (0.27.3) not 0.27.4 (although tagged as 0.27.4.)
I had to uninstall previous version 0.26.x to be able to use 0.27.3 which presents 2 extensions (sp_whoisactive and Server Reports) but no SQL Server Agent. Any ideas ?

from azuredatastudio.

@justPaulo, yeah it looks like they removed it from the extension market place. Don't know why, probably is was too bugged. @kburtram, any idea?

from azuredatastudio.

@SebastianPfliegel we have different extension feeds for the insiders vs. stable builds. Agent extension is only available in the insiders build since it's currently too buggy for stable. We'll try to include it in April stable assume at least the Jobs View and Job History View are ready.

The VSIX is available at https://sqlopsextensions.blob.core.windows.net/march-extensions/agent/agent-0.27.0.vsix and can be manually installed on March stable. I'll produce a new insiders build as soon as we get the VS Code 1.21 source code merged into master. There are several Agent extension improvements that have gone in since we snapped to produce the VSIX, so those should be in the next insiders build as well.

from azuredatastudio.

Hi @SebastianPfliegel @kburtram
I was able to install the SQL Server Agent extension from the .vsix file, thanks.
However, it doesn't show at the bottom of the object tree explorer as usual (nor anywhere else). Guess I'll have to wait for next stable releases.

from azuredatastudio.

It's not showing the step or create new.

from azuredatastudio.

I'll close this now based on the availability of the SQL Agent extension. Please let us know if there are any bugs encountered working with that extension.

from azuredatastudio.