How to install SQL Server Job on Host server using Plesk

I don't want scheduling in asp.net

I just want simple page in .aspx that run below procedure

ALTER PROCEDURE [dbo].[DeleteData] AS
BEGIN
SET NOCOUNT ON;
DELETE FROM Estate_V
WHERE CONVERT(DATE, GETDATE()) = CONVERT(DATE, DATEADD(DAY,[AD] , [DateAD]))
END

for sending email in .aspx page we should write below code

<% @Page Language=”C#” %>
<% @Import Namespace=”System.Net” %>
<% @Import Namespace=”System.Net.Mail” %>
<%
string to = “email@skylarkhost.com”;
string From = “emailF@skylarkhost.com”;
string Sub = “SKYLARKHOST.COM”;

MailMessage m = new MailMessage();
m.From = new MailAddress(From);
m.To.Add(new MailAddress(to));
m.Subject = Sub;
m.Body = “How are you?”;

m.IsBodyHtml = true;
SmtpClient smtp = new SmtpClient(“smtp server”, Give Port number);
smtp.Credentials = new NetworkCredential(From, “give smtp Password”);
smtp.EnableSsl = true;
smtp.Send(m);
m.Dispose();
%>

I want something like this that run my procedure in .aspx

Thanks again

So you can call this SP as you generally call other SPs in your project. Just make use of ExecuteNonQuery

ok

but when I call SP I called that in .aspx.cs  page

but I want call it in .aspx page

see for sending email in below link They write code in .aspx page

I want call SP in .aspx page or write some code that do something like SP...

http://code.ntalive.info/2010/08/18/plesk-scheduler-to-run-an-aspx-file/

<% @Page Language=”C#” %>
<% @Import Namespace=”System.Net” %>
<% @Import Namespace=”System.Net.Mail” %>
<%
string to = “email@skylarkhost.com”;
string From = “emailF@skylarkhost.com”;
string Sub = “SKYLARKHOST.COM”;
 
MailMessage m = new MailMessage();
m.From = new MailAddress(From);
m.To.Add(new MailAddress(to));
m.Subject = Sub;
m.Body = “How are you?”;
 
m.IsBodyHtml = true;
SmtpClient smtp = new SmtpClient(“smtp server”, Give Port number);
smtp.Credentials = new NetworkCredential(From, “give smtp Password”);
smtp.EnableSsl = true;
smtp.Send(m);
m.Dispose();
%>

This is ASP Code and cannot be used for ASP.Net

but they save this file with .aspx  extentions

and usebelow code

<% @Import Namespace=”System.Net” %>