The specified '@notify_email_operator_name' is invalid while deploy a database projectIssues with Log...

Why are there 40 737 Max planes in flight when they have been grounded as not airworthy?

Why do Australian milk farmers need to protest supermarkets' milk price?

Is a lawful good "antagonist" effective?

Rejected in 4th interview round citing insufficient years of experience

Could the Saturn V actually have launched astronauts around Venus?

At what level can a dragon innately cast its spells?

Why doesn't the EU now just force the UK to choose between referendum and no-deal?

Why must traveling waves have the same amplitude to form a standing wave?

Theorems like the Lovász Local Lemma?

It's a yearly task, alright

Rules about breaking the rules. How do I do it well?

Can elves maintain concentration in a trance?

Professor being mistaken for a grad student

Why using two cd commands in bash script does not execute the second command

Good allowance savings plan?

Did CPM support custom hardware using device drivers?

Is it true that real estate prices mainly go up?

How to write cleanly even if my character uses expletive language?

Identifying the interval from A♭ to D♯

2D counterpart of std::array in C++17

Where is the 1/8 CR apprentice in Volo's Guide to Monsters?

Have researchers managed to "reverse time"? If so, what does that mean for physics?

How is the Swiss post e-voting system supposed to work, and how was it wrong?

What has been your most complicated TikZ drawing?



The specified '@notify_email_operator_name' is invalid while deploy a database project


Issues with Log ShippingSSIS package hits “login failed for user” when simultaneous operations occur against the same target databaseFailed to deploy the project. Try again later. (Microsoft SQL Server, Error: 27118)DACPAC and database drift: db users are always detected as drift even when nothing has changedVisual Studio database project and Enity Framework code-firstSSDT publish multiple referenced database projects to new instanceHow to avoid dropping schemas when publishing DB in SSDT Database projecthow do you reference server logins from a visual Studio database project?How to delete stored procedures from a database project and have that reflect on the server?The column was specified multiple times













0















I'm trying to deploy a dacpac and encounter with




Error SQL72014: .Net SqlClient Data Provider: Msg 14234, Level 16,
State 1, Procedure sp_verify_job, Line 245 The specified
'@notify_email_operator_name' is invalid (valid values are returned by
sp_help_operator)




I found a similar topic on SO. According to the instruction, I search the database project of the dacpac but surprisingly, I couldn't find any script which is using notify_email_operator_name parameter.



I also check the server which has the database deployed to mimic Database Email configuration of both profile and account to the target server.
Plus, create all the operators the deployed database had on the target server.



But none of them worked.



Any direction will be appreciated.









share



























    0















    I'm trying to deploy a dacpac and encounter with




    Error SQL72014: .Net SqlClient Data Provider: Msg 14234, Level 16,
    State 1, Procedure sp_verify_job, Line 245 The specified
    '@notify_email_operator_name' is invalid (valid values are returned by
    sp_help_operator)




    I found a similar topic on SO. According to the instruction, I search the database project of the dacpac but surprisingly, I couldn't find any script which is using notify_email_operator_name parameter.



    I also check the server which has the database deployed to mimic Database Email configuration of both profile and account to the target server.
    Plus, create all the operators the deployed database had on the target server.



    But none of them worked.



    Any direction will be appreciated.









    share

























      0












      0








      0








      I'm trying to deploy a dacpac and encounter with




      Error SQL72014: .Net SqlClient Data Provider: Msg 14234, Level 16,
      State 1, Procedure sp_verify_job, Line 245 The specified
      '@notify_email_operator_name' is invalid (valid values are returned by
      sp_help_operator)




      I found a similar topic on SO. According to the instruction, I search the database project of the dacpac but surprisingly, I couldn't find any script which is using notify_email_operator_name parameter.



      I also check the server which has the database deployed to mimic Database Email configuration of both profile and account to the target server.
      Plus, create all the operators the deployed database had on the target server.



      But none of them worked.



      Any direction will be appreciated.









      share














      I'm trying to deploy a dacpac and encounter with




      Error SQL72014: .Net SqlClient Data Provider: Msg 14234, Level 16,
      State 1, Procedure sp_verify_job, Line 245 The specified
      '@notify_email_operator_name' is invalid (valid values are returned by
      sp_help_operator)




      I found a similar topic on SO. According to the instruction, I search the database project of the dacpac but surprisingly, I couldn't find any script which is using notify_email_operator_name parameter.



      I also check the server which has the database deployed to mimic Database Email configuration of both profile and account to the target server.
      Plus, create all the operators the deployed database had on the target server.



      But none of them worked.



      Any direction will be appreciated.







      sql-server-2012 database-projects data-tier-application





      share












      share










      share



      share










      asked 5 mins ago









      蕭為元蕭為元

      1708




      1708






















          0






          active

          oldest

          votes











          Your Answer








          StackExchange.ready(function() {
          var channelOptions = {
          tags: "".split(" "),
          id: "182"
          };
          initTagRenderer("".split(" "), "".split(" "), channelOptions);

          StackExchange.using("externalEditor", function() {
          // Have to fire editor after snippets, if snippets enabled
          if (StackExchange.settings.snippets.snippetsEnabled) {
          StackExchange.using("snippets", function() {
          createEditor();
          });
          }
          else {
          createEditor();
          }
          });

          function createEditor() {
          StackExchange.prepareEditor({
          heartbeatType: 'answer',
          autoActivateHeartbeat: false,
          convertImagesToLinks: false,
          noModals: true,
          showLowRepImageUploadWarning: true,
          reputationToPostImages: null,
          bindNavPrevention: true,
          postfix: "",
          imageUploader: {
          brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
          contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
          allowUrls: true
          },
          onDemand: true,
          discardSelector: ".discard-answer"
          ,immediatelyShowMarkdownHelp:true
          });


          }
          });














          draft saved

          draft discarded


















          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f232209%2fthe-specified-notify-email-operator-name-is-invalid-while-deploy-a-database-p%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown

























          0






          active

          oldest

          votes








          0






          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes
















          draft saved

          draft discarded




















































          Thanks for contributing an answer to Database Administrators Stack Exchange!


          • Please be sure to answer the question. Provide details and share your research!

          But avoid



          • Asking for help, clarification, or responding to other answers.

          • Making statements based on opinion; back them up with references or personal experience.


          To learn more, see our tips on writing great answers.




          draft saved


          draft discarded














          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f232209%2fthe-specified-notify-email-operator-name-is-invalid-while-deploy-a-database-p%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown





















































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown

































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown







          Popular posts from this blog

          ORA-01691 (unable to extend lob segment) even though my tablespace has AUTOEXTEND onORA-01692: unable to...

          Always On Availability groups resolving state after failover - Remote harden of transaction...

          Circunscripción electoral de Guipúzcoa Referencias Menú de navegaciónLas claves del sistema electoral en...