how to auto query ?

11/02/2015 02:04 B13.#1
hey guys i wanna know is there is a way to make a query executed every 24h
?
like a scheduler or something
11/02/2015 05:56 ​Goofie​#2
Cronjob from PHP etc.
Or code your own C# program.

There is a lot of ugly ways to do it as well.
11/02/2015 09:52 B13.#3
the easiest way ?
11/02/2015 10:41 ​Exo#4
SQL Agent, anyone?
11/02/2015 12:32 B13.#5
Quote:
Originally Posted by ​Exo View Post
SQL Agent, anyone?
that is the timed job thing i found that on google, but couldn't find SQL Server Agent in my DB
11/04/2015 09:47 Anonymous-6723#6
Because you are using the express version most likely, get a better one :)
Dev edition has it for sure :)
11/04/2015 10:43 B13.#7
Quote:
Originally Posted by Zed* View Post
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 ?
11/04/2015 18:55 Anonymous-6723#8
Then find yourself a way to add SQL Server Agent, or just do it php sided from your website and there you go :)
11/04/2015 19:18 B13.#9
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
11/04/2015 19:25 mtnman33#10
here you go > [Only registered and activated users can see links. Click Here To Register...]
11/04/2015 19:30 AceSpace#11
Quote:
Originally Posted by ​Exo View Post
SQL Agent, anyone?
+1 for this. SQL Agent is the best for this.
11/05/2015 22:06 B13.#12
Quote:
Originally Posted by mtnman33 View Post
here you go > [Only registered and activated users can see links. Click Here To Register...]
i'm having a hard time with it can you explain how to use ?