is it possible to trim the table output for a specific job? Announcing the arrival of Valued...
Generate an RGB colour grid
Is CEO the "profession" with the most psychopaths?
Is there any word for a place full of confusion?
What does it mean that physics no longer uses mechanical models to describe phenomena?
Why is it faster to reheat something than it is to cook it?
Project Euler #1 in C++
What do you call the main part of a joke?
How would a mousetrap for use in space work?
What order were files/directories outputted in dir?
Most bit efficient text communication method?
Why weren't discrete x86 CPUs ever used in game hardware?
AppleTVs create a chatty alternate WiFi network
How do I find out the mythology and history of my Fortress?
Strange behavior of Object.defineProperty() in JavaScript
What is the meaning of 'breadth' in breadth first search?
Effects on objects due to a brief relocation of massive amounts of mass
"Lost his faith in humanity in the trenches of Verdun" — last line of an SF story
Time to Settle Down!
Has negative voting ever been officially implemented in elections, or seriously proposed, or even studied?
Crossing US/Canada Border for less than 24 hours
Co-worker has annoying ringtone
Sum letters are not two different
What does Turing mean by this statement?
Why are vacuum tubes still used in amateur radios?
is it possible to trim the table output for a specific job?
Announcing the arrival of Valued Associate #679: Cesar Manara
Planned maintenance scheduled April 23, 2019 at 00:00UTC (8:00pm US/Eastern)In Change Data Capture (CDC), how to configure retention with success?Shrink database operation in maintenance plan failedExecuting a SQL Job only once a month and after completion of a specific jobIterating over the output of a SQL query with PowerShellIs it possible for a user that is not the job owner to edit the job or add new steps?SQL Server: Frequent Login timeout expired in Linked serverSSRS - ERROR NUMBER:7357 while passing multiple value parameters using comma delimited string to stored procedurehow to send email message with the results of a job?How can I update statistics adding the data of the last day only?SQL agent jobs hung state (SSIS jobs hung)
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0;
}
I have a routine to save the logins and apply them on a different server , and I run this routine from a job that I have scheduled to run everyday.
On that job I have specified these 3 things:
- Log to table
- Append output to existing entry in table
- Include step output in history
as can be seen on the picture below:
I am happy with that, however, I was wondering if there is a way to trim the table output because when I open it I see records from over 4 months ago, which are no longer relevant now, as shown on the picture below:
when I click View:
I get:
and the table has over 61 thousand lines.
Every time the job runs it adds about 600 new lines to the bottom of the table.
Can I keep the last let's say 10 thousand lines only,getting rid of the older lines?
sql-server jobs scripting logs troubleshooting
asked 3 mins ago
marcello miorellimarcello miorelli
6,2062265150
add a comment |
I have a routine to save the logins and apply them on a different server , and I run this routine from a job that I have scheduled to run everyday.
On that job I have specified these 3 things:
- Log to table
- Append output to existing entry in table
- Include step output in history
as can be seen on the picture below:
I am happy with that, however, I was wondering if there is a way to trim the table output because when I open it I see records from over 4 months ago, which are no longer relevant now, as shown on the picture below:
when I click View:
I get:
and the table has over 61 thousand lines.
Every time the job runs it adds about 600 new lines to the bottom of the table.
Can I keep the last let's say 10 thousand lines only,getting rid of the older lines?
sql-server jobs scripting logs troubleshooting
asked 3 mins ago
marcello miorellimarcello miorelli
6,2062265150
add a comment |
I have a routine to save the logins and apply them on a different server , and I run this routine from a job that I have scheduled to run everyday.
On that job I have specified these 3 things:
- Log to table
- Append output to existing entry in table
- Include step output in history
as can be seen on the picture below:
I am happy with that, however, I was wondering if there is a way to trim the table output because when I open it I see records from over 4 months ago, which are no longer relevant now, as shown on the picture below:
when I click View:
I get:
and the table has over 61 thousand lines.
Every time the job runs it adds about 600 new lines to the bottom of the table.
Can I keep the last let's say 10 thousand lines only,getting rid of the older lines?
sql-server jobs scripting logs troubleshooting
asked 3 mins ago
marcello miorellimarcello miorelli
6,2062265150
I have a routine to save the logins and apply them on a different server , and I run this routine from a job that I have scheduled to run everyday.
On that job I have specified these 3 things:
- Log to table
- Append output to existing entry in table
- Include step output in history
as can be seen on the picture below:
I am happy with that, however, I was wondering if there is a way to trim the table output because when I open it I see records from over 4 months ago, which are no longer relevant now, as shown on the picture below:
when I click View:
I get:
and the table has over 61 thousand lines.
Every time the job runs it adds about 600 new lines to the bottom of the table.
Can I keep the last let's say 10 thousand lines only,getting rid of the older lines?
sql-server jobs scripting logs troubleshooting
sql-server jobs scripting logs troubleshooting
asked 3 mins ago
marcello miorellimarcello miorelli
6,2062265150
asked 3 mins ago
marcello miorellimarcello miorelli
6,2062265150
asked 3 mins ago
marcello miorellimarcello miorelli
6,2062265150
asked 3 mins ago
marcello miorellimarcello miorelli
6,2062265150
asked 3 mins ago
marcello miorellimarcello miorelli
6,2062265150
6,2062265150
add a comment |
add a comment |
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
});
}
});
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%2fdba.stackexchange.com%2fquestions%2f235274%2fis-it-possible-to-trim-the-table-output-for-a-specific-job%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 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.
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%2fdba.stackexchange.com%2fquestions%2f235274%2fis-it-possible-to-trim-the-table-output-for-a-specific-job%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
