SQL Server Server Agent Job syntax meaningAdd a column with a default value to an existing table in SQL ServerHow to return only the Date from a SQL Server DateTime datatypeHow to check if a column exists in a SQL Server table?Check if table exists in SQL ServerHow to concatenate text from multiple rows into a single text string in SQL server?LEFT JOIN vs. LEFT OUTER JOIN in SQL ServerInserting multiple rows in a single SQL query?How do I UPDATE from a SELECT in SQL Server?Not able to create Job in SQL?How to Delete using INNER JOIN with SQL Server?

I sent an angry e-mail to my interviewers about a conflict at my home institution. Could this affect my application?

usage of mir gefallen

Background for black and white chart

Can artificial satellite positions affect tides?

Can an escape pod land on Earth from orbit and not be immediately detected?

Am I being scammed by a sugar daddy?

ISP is not hashing the password I log in with online. Should I take any action?

Fastest way from 10 to 1 with everyone in between

The best in flight meal option for those suffering from reflux

Why would a home insurer offer a discount based on credit score?

Is it true that "only photographers care about noise"?

Is it ethical to cite a reviewer's papers even if they are rather irrelevant?

I received a gift from my sister who just got back from

Parallelized for loop in Bash

Why did Robert pick unworthy men for the White Cloaks?

Any gotchas in buying second-hand sanitary ware?

What is Gilligan's full name?

What publication claimed that Michael Jackson died in a nuclear holocaust?

How can I find out about the game world without meta-influencing it?

What do you call the action of "describing events as they happen" like sports anchors do?

Why is it bad to use your whole foot in rock climbing

Purpose of cylindrical attachments on Power Transmission towers

How effective would a full set of plate armor be against wild animals found in temperate regions (bears, snakes, wolves)?

French citizen, did I need a visa in 2004 and 2006 when I visited the US as a child?



SQL Server Server Agent Job syntax meaning


Add a column with a default value to an existing table in SQL ServerHow to return only the Date from a SQL Server DateTime datatypeHow to check if a column exists in a SQL Server table?Check if table exists in SQL ServerHow to concatenate text from multiple rows into a single text string in SQL server?LEFT JOIN vs. LEFT OUTER JOIN in SQL ServerInserting multiple rows in a single SQL query?How do I UPDATE from a SELECT in SQL Server?Not able to create Job in SQL?How to Delete using INNER JOIN with SQL Server?






.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;








0















I have a SQL server agent job, and this is the script to create one of its steps:



EXEC @ReturnCode = msdb.dbo.sp_add_jobstep @job_id=@jobId, @step_name=N'Load data and Email enquiries', 
@step_id=1,
@cmdexec_success_code=0,
@on_success_action=3,
@on_success_step_id=0,
@on_fail_action=2,
@on_fail_step_id=0,
@retry_attempts=0,
@retry_interval=0,
@os_run_priority=0, @subsystem=N'SSIS',
@command= 'check details in below'
@database_name=N'master',
@flags=0


IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback



The details of @command string is display in below



N'/SQL ""OdinOds LoadersLoadDataInfolink"" /SERVER ServerName1 /CONNECTION ""Destination_db"";""Data Source=my_data_source;User ID=user1;password=password1;Initial Catalog=catalog1;Provider=SQLNCLI11.1;Persist Security Info=True;Auto Translate=false;"" /CONNECTION ""Source_db"";""Data Source=server2;User ID=user1;password=password1;Initial Catalog=db3;Provider=SQLNCLI11.1;Persist Security Info=True;Auto Translate=false;"" /CHECKPOINTING OFF /REPORTING E', 


What I want to know is the meaning of the beginning part



/SQL ""OdinOds LoadersLoadDataInfolink""


is that LoadDataInfolink a stored procedure or something?










share|improve this question






























    0















    I have a SQL server agent job, and this is the script to create one of its steps:



    EXEC @ReturnCode = msdb.dbo.sp_add_jobstep @job_id=@jobId, @step_name=N'Load data and Email enquiries', 
    @step_id=1,
    @cmdexec_success_code=0,
    @on_success_action=3,
    @on_success_step_id=0,
    @on_fail_action=2,
    @on_fail_step_id=0,
    @retry_attempts=0,
    @retry_interval=0,
    @os_run_priority=0, @subsystem=N'SSIS',
    @command= 'check details in below'
    @database_name=N'master',
    @flags=0


    IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback



    The details of @command string is display in below



    N'/SQL ""OdinOds LoadersLoadDataInfolink"" /SERVER ServerName1 /CONNECTION ""Destination_db"";""Data Source=my_data_source;User ID=user1;password=password1;Initial Catalog=catalog1;Provider=SQLNCLI11.1;Persist Security Info=True;Auto Translate=false;"" /CONNECTION ""Source_db"";""Data Source=server2;User ID=user1;password=password1;Initial Catalog=db3;Provider=SQLNCLI11.1;Persist Security Info=True;Auto Translate=false;"" /CHECKPOINTING OFF /REPORTING E', 


    What I want to know is the meaning of the beginning part



    /SQL ""OdinOds LoadersLoadDataInfolink""


    is that LoadDataInfolink a stored procedure or something?










    share|improve this question


























      0












      0








      0








      I have a SQL server agent job, and this is the script to create one of its steps:



      EXEC @ReturnCode = msdb.dbo.sp_add_jobstep @job_id=@jobId, @step_name=N'Load data and Email enquiries', 
      @step_id=1,
      @cmdexec_success_code=0,
      @on_success_action=3,
      @on_success_step_id=0,
      @on_fail_action=2,
      @on_fail_step_id=0,
      @retry_attempts=0,
      @retry_interval=0,
      @os_run_priority=0, @subsystem=N'SSIS',
      @command= 'check details in below'
      @database_name=N'master',
      @flags=0


      IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback



      The details of @command string is display in below



      N'/SQL ""OdinOds LoadersLoadDataInfolink"" /SERVER ServerName1 /CONNECTION ""Destination_db"";""Data Source=my_data_source;User ID=user1;password=password1;Initial Catalog=catalog1;Provider=SQLNCLI11.1;Persist Security Info=True;Auto Translate=false;"" /CONNECTION ""Source_db"";""Data Source=server2;User ID=user1;password=password1;Initial Catalog=db3;Provider=SQLNCLI11.1;Persist Security Info=True;Auto Translate=false;"" /CHECKPOINTING OFF /REPORTING E', 


      What I want to know is the meaning of the beginning part



      /SQL ""OdinOds LoadersLoadDataInfolink""


      is that LoadDataInfolink a stored procedure or something?










      share|improve this question
















      I have a SQL server agent job, and this is the script to create one of its steps:



      EXEC @ReturnCode = msdb.dbo.sp_add_jobstep @job_id=@jobId, @step_name=N'Load data and Email enquiries', 
      @step_id=1,
      @cmdexec_success_code=0,
      @on_success_action=3,
      @on_success_step_id=0,
      @on_fail_action=2,
      @on_fail_step_id=0,
      @retry_attempts=0,
      @retry_interval=0,
      @os_run_priority=0, @subsystem=N'SSIS',
      @command= 'check details in below'
      @database_name=N'master',
      @flags=0


      IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback



      The details of @command string is display in below



      N'/SQL ""OdinOds LoadersLoadDataInfolink"" /SERVER ServerName1 /CONNECTION ""Destination_db"";""Data Source=my_data_source;User ID=user1;password=password1;Initial Catalog=catalog1;Provider=SQLNCLI11.1;Persist Security Info=True;Auto Translate=false;"" /CONNECTION ""Source_db"";""Data Source=server2;User ID=user1;password=password1;Initial Catalog=db3;Provider=SQLNCLI11.1;Persist Security Info=True;Auto Translate=false;"" /CHECKPOINTING OFF /REPORTING E', 


      What I want to know is the meaning of the beginning part



      /SQL ""OdinOds LoadersLoadDataInfolink""


      is that LoadDataInfolink a stored procedure or something?







      sql-server






      share|improve this question















      share|improve this question













      share|improve this question




      share|improve this question








      edited Mar 25 at 5:05









      marc_s

      593k13311351279




      593k13311351279










      asked Mar 25 at 0:58









      lucaslucas

      260110




      260110






















          0






          active

          oldest

          votes












          Your Answer






          StackExchange.ifUsing("editor", function ()
          StackExchange.using("externalEditor", function ()
          StackExchange.using("snippets", function ()
          StackExchange.snippets.init();
          );
          );
          , "code-snippets");

          StackExchange.ready(function()
          var channelOptions =
          tags: "".split(" "),
          id: "1"
          ;
          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: true,
          noModals: true,
          showLowRepImageUploadWarning: true,
          reputationToPostImages: 10,
          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%2fstackoverflow.com%2fquestions%2f55330062%2fsql-server-server-agent-job-syntax-meaning%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 Stack Overflow!


          • 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%2fstackoverflow.com%2fquestions%2f55330062%2fsql-server-server-agent-job-syntax-meaning%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

          How to preserve electronics (computers, tablets and phones) for hundreds of years Announcing the arrival of Valued Associate #679: Cesar Manara Planned maintenance scheduled April 23, 2019 at 23:30 UTC (7:30pm US/Eastern) The network's official Twitter account is up and running again. What content…How might modern humans leave a message for 50,000 years?How would an aquatic race develop computers?How do we make computers care for human life?Keeping supplies for 1000 yearsWhat will cell phones become in 100 years?What body armor protects against a laser?Could a society attain 1800s technology if limited to using copper and bronze?Electricity power (magic) and electronicsScavenging metal resources in post-apocalypse after 100 yearsWhy would precursors create devices that can survive and still work after hundreds of years?

          155 수학 과학 기타 둘러보기 메뉴eh추가해eh문서를 완성해

          Convert JSON to MapSimplest way to convert a string representing JSON array into Java array List of key value pairsHow to take String JSON values into HashMapConvert a JSON String to a HashMapCreating BSON object from JSON stringJSONObject - How to get a value ?Better Map ConstructorReading JSON from Url javaUpdate columns if input values are not null otherwise ignore and keep the existing values of column in databaseHow to store object represented as Json string into Couchbase Lite?Go JSON into MapHow do I efficiently iterate over each entry in a Java Map?Sort a Map<Key, Value> by valuesHow to round a number to n decimal places in JavaCan comments be used in JSON?How do I read / convert an InputStream into a String in Java?How can I pretty-print JSON in a shell script?What is the correct JSON content type?How can I deserialize JSON to a simple Dictionary<string,string> in ASP.NET?Why does Google prepend while(1); to their JSON responses?Parse JSON in JavaScript?