functions/Get-DbrAgentJob.ps1
|
Function Get-DbrAgentJob { <# .SYNOPSIS Gets all of the dbareports SQL Agent Job information using the config file .DESCRIPTION Gets all of the dbareports SQL Agent Job information using the config file .PARAMETER Force Displays all of the information rather than the default information .NOTES dbareports PowerShell module (https://dbareports.io, SQLDBAWithABeard.com) Copyright (C) 2016 Rob Sewell This program is free software: you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation, either version 3 of the License, or (at your option) any later version. This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details. You should have received a copy of the GNU General Public License along with this program. If not, see <http://www.gnu.org/licenses/>. .LINK https://dbareports.io/Verb-SqlNoun .EXAMPLE Verb-SqlNoun Copies all policies and conditions from sqlserver2014a to sqlcluster, using Windows credentials. #> [CmdletBinding()] Param ( [switch]$Force ) DynamicParam { Get-Config if ($script:SqlServer) { return (Get-ParamSqlDbrJobs -SqlServer $script:SqlServer -SqlCredential $script:SqlCredential) } } PROCESS { Get-Config $SqlServer = $script:SqlServer $InstallDatabase = $script:InstallDatabase $SqlCredential = $script:SqlCredential if ($SqlServer.length -eq 0) { throw "No config file found. Have you installed dbareports? Please run Install-DbaReports or Install-DbaReportsClient" } $sourceserver = Connect-SqlServer -SqlServer $sqlserver -SqlCredential $SqlCredential $source = $sourceserver.DomainInstanceName $jobserver = $sourceserver.JobServer $jobs = $psboundparameters.Jobs if ($jobs.length -ne 0) { $result = $jobserver.jobs | Where-Object { $jobs -contains $_.Name } } else { $result = $jobserver.jobs | Where-Object { $_.Name -like "*dbareports*" } } if ($force -ne $true) { $result = $result | Select-Object Parent, Category, CurrentRunStatus, CurrentRunStep, DateCreated, DateLastModified, Description, EmailLevel, EventLogLevel, IsEnabled, JobID, LastRunDate, LastRunOutcome, NextRunDate, OperatorToEmail, OperatorToPage, OwnerLoginName, Name, JobSteps, JobSchedules } return $result $sourceserver.ConnectionContext.Disconnect() } } |