Agent Expiry Auto notification send before 30 days Stored Procedure
I am new to SQL Server and I want to create a stored procedure for below requirement.
Agent Expiring automated email notification sent by the system in case any agent is expiring
For Example
- Agent Code :EDSBOMDO code expires on 00DEC2018.
- before 30 days Agent expiry email notification sent to the Agent.
c# asp.net
sql-server asked Nov 20 at 5:07
Balaji Pendharkar
32
add a comment |
I am new to SQL Server and I want to create a stored procedure for below requirement.
Agent Expiring automated email notification sent by the system in case any agent is expiring
For Example
- Agent Code :EDSBOMDO code expires on 00DEC2018.
- before 30 days Agent expiry email notification sent to the Agent.
c# asp.net
sql-server asked Nov 20 at 5:07
Balaji Pendharkar
32
add a comment |
I am new to SQL Server and I want to create a stored procedure for below requirement.
Agent Expiring automated email notification sent by the system in case any agent is expiring
For Example
- Agent Code :EDSBOMDO code expires on 00DEC2018.
- before 30 days Agent expiry email notification sent to the Agent.
c# asp.net
sql-server asked Nov 20 at 5:07
Balaji Pendharkar
32
I am new to SQL Server and I want to create a stored procedure for below requirement.
Agent Expiring automated email notification sent by the system in case any agent is expiring
For Example
- Agent Code :EDSBOMDO code expires on 00DEC2018.
- before 30 days Agent expiry email notification sent to the Agent.
c# asp.net
sql-server c# asp.net
sql-server asked Nov 20 at 5:07
Balaji Pendharkar
32
asked Nov 20 at 5:07
Balaji Pendharkar
32
edited Nov 20 at 9:01
asked Nov 20 at 5:07
Balaji Pendharkar
32
asked Nov 20 at 5:07
Balaji Pendharkar
32
asked Nov 20 at 5:07
Balaji Pendharkar
32
32
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
Your requirement is not clear
but I'll assume those are custom data fields
I'd say you can do it via SQL Agent
Run it daily and send out email for expiring AgentCode within 30 days
pseudo-code
SELECT agentEmail FROM table WHERE ExpiryDate < GETDATE()+30
If @@ROWCOUNT > 1
Email all these agents
answered Nov 20 at 5:27
Jerry Hung
562
add a comment |
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%2f53386559%2fagent-expiry-auto-notification-send-before-30-days-stored-procedure%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Your requirement is not clear
but I'll assume those are custom data fields
I'd say you can do it via SQL Agent
Run it daily and send out email for expiring AgentCode within 30 days
pseudo-code
SELECT agentEmail FROM table WHERE ExpiryDate < GETDATE()+30
If @@ROWCOUNT > 1
Email all these agents
answered Nov 20 at 5:27
Jerry Hung
562
add a comment |
Your requirement is not clear
but I'll assume those are custom data fields
I'd say you can do it via SQL Agent
Run it daily and send out email for expiring AgentCode within 30 days
pseudo-code
SELECT agentEmail FROM table WHERE ExpiryDate < GETDATE()+30
If @@ROWCOUNT > 1
Email all these agents
answered Nov 20 at 5:27
Jerry Hung
562
add a comment |
Your requirement is not clear
but I'll assume those are custom data fields
I'd say you can do it via SQL Agent
Run it daily and send out email for expiring AgentCode within 30 days
pseudo-code
SELECT agentEmail FROM table WHERE ExpiryDate < GETDATE()+30
If @@ROWCOUNT > 1
Email all these agents
answered Nov 20 at 5:27
Jerry Hung
562
Your requirement is not clear
but I'll assume those are custom data fields
I'd say you can do it via SQL Agent
Run it daily and send out email for expiring AgentCode within 30 days
pseudo-code
SELECT agentEmail FROM table WHERE ExpiryDate < GETDATE()+30
If @@ROWCOUNT > 1
Email all these agents
answered Nov 20 at 5:27
Jerry Hung
562
answered Nov 20 at 5:27
Jerry Hung
562
answered Nov 20 at 5:27
Jerry Hung
562
answered Nov 20 at 5:27
Jerry Hung
562
562
add a comment |
add a comment |
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.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- 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%2f53386559%2fagent-expiry-auto-notification-send-before-30-days-stored-procedure%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
