set Sqljob in plesk panel

[neda_sh]

HI There

I use sqljob in my database in this job I define that every day it delete some data from my website i tested it in local host
Now I want do it in my host But I don't know how I can do it?

I make sqljob scrtipt and I have this job query .
I don't know HOw I can run this query in my plesk panel

some body told me that I should wrote VB code and put it in Schedular task
but I don't know How I can do it?

can you help me??
I really need your help.
my plesk panel is 9.5.5

BEST REGARDS

 

[Grigoriy]

You may use different ways.
For example you can try to use simple .bat file in scheduler to run your script using sqlcmd.
http://msdn.microsoft.com/en-us/library/ms180944(v=sql.105).aspx