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

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*

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

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

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 ?