how to auto query ?

[B13.]

hey guys i wanna know is there is a way to make a query executed every 24h
?
like a scheduler or something

[​Goofie​]

Cronjob from PHP etc.
Or code your own C# program.

There is a lot of ugly ways to do it as well.

[B13.]

the easiest way ?

[​Exo]

SQL Agent, anyone?

[B13.]

Originally Posted by ​Exo

SQL Agent, anyone?

that is the timed job thing i found that on google, but couldn't find SQL Server Agent in my DB

[Anonymous-6723]

Because you are using the express version most likely, get a better one
Dev edition has it for sure

[B13.]

Originally Posted by Zed*

Because you are using the express version most likely, get a better one
Dev edition has it for sure

what if i don't want to change ?

[Anonymous-6723]

Then find yourself a way to add SQL Server Agent, or just do it php sided from your website and there you go

[B13.]

if i know how to do it in any way php/sql , trust me i wont be asking how ;-;
give me steps to follow or a punch of tips

[mtnman33]

here you go >

[AceSpace]

Originally Posted by ​Exo

SQL Agent, anyone?

+1 for this. SQL Agent is the best for this.

[B13.]

Originally Posted by mtnman33

here you go >

i'm having a hard time with it can you explain how to use ?