ok
I search and find some information
I can't run my query I should save code in .aspx file and execute it in schedual task in plesk panel
refer:
http://code.ntalive.info/2010/08/18/plesk-scheduler-to-run-an-aspx-file/
in above link it explain about sending email
but i want run my procedure that I define for sqljob in my database
How I can define it in .aspx file ,
I mean I want wrote my store procedure in .aspx file that delete data from table
untill I execute it in plesk panel
Thanks again.
ALTER PROCEDURE [dbo].[DeleteData] AS
BEGIN
SET NOCOUNT ON;
DELETE FROM Estate_V
WHERE CONVERT(DATE, GETDATE()) = CONVERT(DATE, DATEADD(DAY,[AD] , [DateAD]))
END
