Azuredatastudio: Unable to stop a job after running it from SQL Agent.

[wsmelton]

• Azure Data Studio Version:

Version 1.4.5
Commit 887f4e8985023602e599cf86bdb44df48bb28569
Date 2019-02-12T06:20:08.633Z
VS Code 1.26.1
Shell 2.0.9
Renderer 61.0.3163.100
Node 8.9.3
V8: 6.1.534.41
Architecture x64

Steps to Reproduce:

1. Connect to server
2. Bring up manage editor
3. Click on SQL Agent dashboard
4. Select a job
5. Click Run
6. The stop button is never usable

I expect once I click on Run to be able immediately stop the job. Even clicking on refresh for a long running job does not allow you to stop it once you started it via ADS.

[yualan]

@abist Can you take a look at this tomorrow? Greatly appreciated :)

[wsmelton]

Trying this on a job that has multiple steps and one that I know runs for over 4 hours. I started the job at 3:00:08 AM UTC. I know the job is still running, but the view given by SQL Agent is that it succeeded, but the view of all the steps is completely false in the details....none of the steps shown failed on this run (some have not even run yet)....

Unsure if this is all connected to why that stop button is not available, but the screenshot below the job time slot I have selected is still running on the server:

[abist]

@wsmelton Thanks for reporting this bug! Just to make sure, the job was still running and yet it showed it succeeded with failing steps?

[wsmelton]

Correct