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.

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

sp_BlitzLock errors on Amazon RDS SQL Server Express Edition when it tries to query sysjobsteps #2317

Closed
Ernesto-Ibanez opened this issue Feb 28, 2020 · 1 comment
Assignees
Labels

Comments

@Ernesto-Ibanez
Copy link

@Ernesto-Ibanez Ernesto-Ibanez commented Feb 28, 2020

Version of the script
/****** Object: StoredProcedure [dbo].[sp_BlitzLock] Script Date: 28/02/2020 02:37:49 p. m. ******/

What is the current behavior?
Grab the initial set of XML to parse at Feb 28 2020 8:04:19:573PM
Parse process and input buffer XML Feb 28 2020 8:04:35:877PM
Parse execution stack XML Feb 28 2020 8:04:35:937PM
Grab the full resource list Feb 28 2020 8:04:35:937PM
Parse object locks Feb 28 2020 8:04:35:953PM
Parse page locks Feb 28 2020 8:04:35:967PM
Parse key locks Feb 28 2020 8:04:35:983PM
Parse RID locks Feb 28 2020 8:04:36:013PM
Parse row group locks Feb 28 2020 8:04:36:027PM
Parse parallel deadlocks Feb 28 2020 8:04:36:057PM
Get rid of parallel noise Feb 28 2020 8:04:36:073PM
Get rid of nonsense Feb 28 2020 8:04:36:087PM
Update some nonsense part 1 Feb 28 2020 8:04:36:087PM
Update some nonsense part 2 Feb 28 2020 8:04:36:103PM
Get Agent Job and Step names Feb 28 2020 8:04:36:103PM
Msg 229, Level 14, State 5, Line 19
The SELECT permission was denied on the object 'sysjobsteps', database 'msdb', schema 'dbo'.
Check 1 Feb 28 2020 8:04:36:117PM
Check 2 objects Feb 28 2020 8:04:36:117PM
Check 2 indexes Feb 28 2020 8:04:36:133PM
Check 3 Feb 28 2020 8:04:36:133PM
Check 4 Feb 28 2020 8:04:36:133PM
Check 5 Feb 28 2020 8:04:36:133PM
Check 6 Feb 28 2020 8:04:36:147PM
Check 7 part 1 Feb 28 2020 8:04:36:163PM
Check 7 part 2 Feb 28 2020 8:04:36:177PM
Check 8 Feb 28 2020 8:04:36:177PM
Check 9 Feb 28 2020 8:04:36:193PM
Check 10 Feb 28 2020 8:04:36:193PM
Check 11 Feb 28 2020 8:04:36:193PM
Check 12 Feb 28 2020 8:04:36:207PM
Results 1 Feb 28 2020 8:04:36:207PM
Findings Feb 28 2020 8:04:36:223PM
Done Feb 28 2020 8:04:36:223PM

Completion time: 2020-02-28T14:04:37.2069754-06:00

If the current behavior is a bug, please provide the steps to reproduce.
Just EXEC sp_BlitzLock

Which versions of SQL Server and which OS are affected by this issue? Did this work in previous versions of our procedures?

Engine
SQL Server Express Edition

Class
db.t2.small
AWS Under RDS

Version: Microsoft SQL Server 2017 (RTM-CU16) (KB4508218) - 14.0.3223.3 (X64) Jul 12 2019 17:43:08 Copyright (C) 2017 Microsoft Corporation Express Edition (64-bit) on Windows Server 2016 Datacenter 10.0 (Build 14393: ) (Hypervisor)

@BrentOzar BrentOzar self-assigned this Feb 29, 2020
@BrentOzar BrentOzar added this to the 2020-03 Release milestone Feb 29, 2020
BrentOzar added a commit that referenced this issue Feb 29, 2020
Works with Express Edition on RDS. Closes #2317.
BrentOzar added a commit that referenced this issue Feb 29, 2020
#2317 sp_BlitzLock on Amazon RDS
@BrentOzar BrentOzar changed the title Raise Error when running sp_BlitzLock sp_BlitzLock errors on Amazon RDS SQL Server Express Edition when it tries to query sysjobsteps Feb 29, 2020
@BrentOzar

This comment has been minimized.

Copy link
Member

@BrentOzar BrentOzar commented Feb 29, 2020

Fixed in the dev branch, and it'll be in the March release. Thanks!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Linked pull requests

Successfully merging a pull request may close this issue.

2 participants
You can’t perform that action at this time.