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