tests/New-DbaAgentJobStep.Tests.ps1
|
$CommandName = $MyInvocation.MyCommand.Name.Replace(".Tests.ps1", "") Write-Host -Object "Running $PSCommandpath" -ForegroundColor Cyan . "$PSScriptRoot\constants.ps1" Describe "$CommandName Integration Tests" -Tags "IntegrationTests" { Context "New Agent Job Step is added properly" { AfterAll { Remove-DbaAgentJob -SqlInstance $script:instance2 -Job "dbatoolsci Job One" } # Create job to add step to $job = New-DbaAgentJob -SqlInstance $script:instance2 -Job "dbatoolsci Job One" -Description "Just another job" It "Should have the right name and description" { $results = New-DbaAgentJobStep -SqlInstance $script:instance2 -Job $job -StepName "Step One" $results.Name | Should -Be "Step One" } It "Should actually for sure exist" { $newresults = Get-DbaAgentJob -SqlInstance $script:instance2 -Job "dbatoolsci Job One" $newresults.JobSteps.Name | Should -Be "Step One" } It "Should not write over existing job steps" { New-DbaAgentJobStep -SqlInstance $script:instance2 -Job "dbatoolsci Job One" -StepName "Step One" -WarningAction SilentlyContinue -WarningVariable warn $warn -match "already exists" | Should -Be $true $newresults = Get-DbaAgentJob -SqlInstance $script:instance2 -Job "dbatoolsci Job One" $newresults.JobSteps.Name | Should -Be "Step One" } It "Force should add jobstep to job and the older job step should be second" { $results = New-DbaAgentJobStep -SqlInstance $script:instance2 -Job "dbatoolsci Job One" -StepName "New Step One" -StepId 1 -Force $results.Name | Should -Be "New Step One" $newresults = Get-DbaAgentJob -SqlInstance $script:instance2 -Job "dbatoolsci Job One" $newresults.JobSteps | Where-Object Id -eq 1 | Select-Object -ExpandProperty Name | Should -Be "New Step One" $newresults.JobSteps | Where-Object Id -eq 2 | Select-Object -ExpandProperty Name | Should -Be "Step One" } } } |