Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Notebook Agent Jobs fail on named instances #2305

Open
SQLDBAWithABeard opened this issue Jan 2, 2024 · 0 comments
Open

Notebook Agent Jobs fail on named instances #2305

SQLDBAWithABeard opened this issue Jan 2, 2024 · 0 comments

Comments

@SQLDBAWithABeard
Copy link

Following the feedback here https://learn.microsoft.com/en-us/answers/questions/1465685/

I realised when trying to replicate on my own lab that Notebook Agent Jobs will never run for named instances as the Invoke-SqlCmd calls have no parameter for ServerInstance
SQLDBAWithABeard added a commit to SQLDBAWithABeard/sqltoolsservice that referenced this issue Jan 2, 2024
@SQLDBAWithABeard
Fixes microsoft#2305 - Enable Notebook Agent Jobs to succeed on named…
c262ddf 
… instances

Adds in Default Parameter value for the ServerInstance parameter of Invoke-SqlCmd with the Agent tokens for the machine and the instance
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@SQLDBAWithABeard