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

Copy-DbaAgentJob failing to migrate job to missing operator even though it does exist on the target instance #59

Open
3xchaos opened this issue Mar 13, 2024 · 0 comments

Comments

@3xchaos
Copy link

3xchaos commented Mar 13, 2024

powershell version 5.1.17763.5458
dbatools 2.1.7
dbatools.library 2023.9.21

Source SQL Version -> Microsoft SQL Server 2016 (SP3-GDR) (KB5029186) - 13.0.6435.1 (X64) Jul 30 2023 19:53:42 Copyright (c) Microsoft Corporation Developer Edition (64-bit) on Windows Server 2016 Standard 10.0 (Build 14393: ) (Hypervisor)

Target SQL Version -> Microsoft SQL Server 2019 (RTM-CU24) (KB5031908) - 15.0.4345.5 (X64) Dec 4 2023 14:44:16 Copyright (C) 2019 Microsoft Corporation Developer Edition (64-bit) on Windows Server 2019 Standard 10.0 (Build 17763: ) (Hypervisor)

Error:

VERBOSE: [19:48:23][Connect-DbaInstance] Connection string is passed in, will build empty server object, set connection string from instance.InputObject, do some checks and then return the
server object
VERBOSE: [19:48:23][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object
VERBOSE: [19:48:23][Copy-DbaAgentJob] Working on job: xxxxxxx
VERBOSE: Performing the operation "Operator(s) doesn't exist on destination. Skipping job [xxxxx]" on target "xxxxxx".

VERBOSE: [19:48:24][Copy-DbaAgentJob] Operator(s) CCITSD doesn't exist on destination. Skipping job [xxxxxxx]

As part of our process we run a Copy-DbaAgentOperator to migrate the operators and we have validated via SSMS that the operator does exist on the target instance.

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

No branches or pull requests

1 participant