Sample Header Ad - 728x90

How can I run SQL Server Vulnerability Assessment from a SQL Job?

4 votes
2 answers
1302 views
I want to run SQL Server Vulnerability Assessment from a SQL Server Agent Job. Currently, I am attempting a job with a PowerShell script and am running a command like the one below. Invoke-SqlVulnerabilityAssessmentScan -ServerInstance $(ESCAPE_DQUOTE(SRVR)) -Database AdventureWorks I have confirmed that Invoke-SqlVulnerabilityAssessmentScan is available on the SQL Server (I can run it from the PowerShell command prompt there), but when I run my job, I receive an error stating that > The term 'Invoke-SqlVulnerabilityAssessmentScan' is not recognized as the name of a cmdlet After looking at this Microsoft article , I am wondering if SQL Agent only has a subset of PowerShell cmdlets that it can access. How can I run the vulnerability assessment scan from a SQL Job?
Asked by Scott (193 rep)
Aug 20, 2019, 01:48 PM
Last activity: Aug 20, 2019, 05:39 PM