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

          SQL error code 1064 with creating Laravel foreign keysForeign key constraints: When to use ON UPDATE and ON DELETEDropping column with foreign key Laravel error: General error: 1025 Error on renameLaravel SQL Can't create tableLaravel Migration foreign key errorLaravel php artisan migrate:refresh giving a syntax errorSQLSTATE[42S01]: Base table or view already exists or Base table or view already exists: 1050 Tableerror in migrating laravel file to xampp serverSyntax error or access violation: 1064:syntax to use near 'unsigned not null, modelName varchar(191) not null, title varchar(191) not nLaravel cannot create new table field in mysqlLaravel 5.7:Last migration creates table but is not registered in the migration table

          용인 삼성생명 블루밍스 목차 통계 역대 감독 선수단 응원단 경기장 같이 보기 외부 링크 둘러보기 메뉴samsungblueminx.comeh선수 명단용인 삼성생명 블루밍스용인 삼성생명 블루밍스ehsamsungblueminx.comeheheheh

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