Get-DbaAgentJobHistory,dbatools

The below powershell command will give the information about SQL Server agent job and its status.
cls
Get-DbaAgentJobHistory `
-SqlInstance ServerNameHere `
-Job 'Job Name Here' `
-WithOutputFile|Where-Object {($_.Rundate -like "*05/06/2021*")} -Verbose|Sort-Object Rundate -Descending|
Format-Table ComputerName,SQLInstance,Job,RunDate,Status,Stepid,Message -Wrap

Comments

Popular posts from this blog

System.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception (0x80004005): The wait operation timed out

Pre login Handshake or Connection Timeout Period

Transparent Data Encryption(TDE) with Master Key and Certificate in SQL Server