ok
I did it
simply write below code on note pad and save it with .vbs Extention
Call Schedule()
Sub Schedule()
On Error Resume Next
Dim objRequest
Dim URL
Set objRequest = CreateObject(“Microsoft.XMLHTTP”)
URL = “http://www.yourdomain.com/test.aspx”
objRequest.open “POST”, URL , false
objRequest.Send
Set objRequest = Nothing
End Sub
and in .aspx page write below code
SqlConnection _cn = new SqlConnection(System.Web.Configuration.WebConfigurationManager.ConnectionStrings["behtopConnectionString"].ConnectionString);
protected void Page_Load(object sender, EventArgs e)
{
SqlCommand _cmd = new SqlCommand("DeleteData", _cn);
_cmd.CommandType = CommandType.StoredProcedure;
_cn.Open();
_cmd.ExecuteNonQuery();
_cn.Close();
}
after that upload .vbs and .aspx file and in plesk panle go to schedualTask menu and create new Task and set date/day/Time for it to run your .vbs file
after set below changes
Switched on: Give Check Mark
Description : Task name
Scheduler notification: Choose any one
Path to executable file * : C:\Windows\system32\cscript.exe
Arguments:C:\Inetpub\vhosts\Your_domain_name\httpdocs\test.vbs arg_1
Task priority: Normal
on time that you define, it run .vbs file that on this file is your .aspx file address to run
Thanks
