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;
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?
add a comment |
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?
add a comment |
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?
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?
edited Mar 25 at 5:05
marc_s
593k13311351279
593k13311351279
asked Mar 25 at 0:58
lucaslucas
260110
260110
add a comment |
add a comment |
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
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
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
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.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
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
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
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