Navigacija
Lista poslednjih: 16, 32, 64, 128 poruka.

automatsko pokretanje upita

[es] :: MySQL :: automatsko pokretanje upita

[ Pregleda: 2213 | Odgovora: 2 ] > FB > Twit

Postavi temu Odgovori

Autor

Pretraga teme: Traži
Markiranje Štampanje RSS

bigguy
borisav ignjatov
nista
zrenjanin

Član broj: 87859
Poruke: 267
*.dialup.neobee.net.



+1 Profil

icon automatsko pokretanje upita09.04.2006. u 16:42 - pre 219 meseci
da li je moguce pokrenuti upit u zadato vreme i kako? inace radim sa MySQL 5
 
Odgovor na temu

Gojko Vujovic
Amsterdam, NL

Administrator
Član broj: 1
Poruke: 13651



+165 Profil

icon Re: automatsko pokretanje upita09.04.2006. u 17:13 - pre 219 meseci
To više zavisi od operativnog sistema.

Za windows:


C:\WINDOWS>help at
The AT command schedules commands and programs to run on a computer at
a specified time and date. The Schedule service must be running to use
the AT command.

AT [\\computername] [ [id] [/DELETE] | /DELETE [/YES]]
AT [\\computername] time [/INTERACTIVE]
[ /EVERY:date[,...] | /NEXT:date[,...]] "command"

\\computername Specifies a remote computer. Commands are scheduled on the
local computer if this parameter is omitted.
id Is an identification number assigned to a scheduled
command.
/delete Cancels a scheduled command. If id is omitted, all the
scheduled commands on the computer are canceled.
/yes Used with cancel all jobs command when no further
confirmation is desired.
time Specifies the time when command is to run.
/interactive Allows the job to interact with the desktop of the user
who is logged on at the time the job runs.
/every:date[,...] Runs the command on each specified day(s) of the week or
month. If date is omitted, the current day of the month
is assumed.
/next:date[,...] Runs the specified command on the next occurrence of the
day (for example, next Thursday). If date is omitted, the
current day of the month is assumed.
"command" Is the Windows NT command, or batch program to be run.


Na linux/unix sistemu pogledaj


man cron
 
Odgovor na temu

bigguy
borisav ignjatov
nista
zrenjanin

Član broj: 87859
Poruke: 267
*.dialup.neobee.net.



+1 Profil

icon Re: automatsko pokretanje upita09.04.2006. u 18:01 - pre 219 meseci
ok tako, ali da li je moguce automatski pokrenuti upit samo uz pomoc sql-a tj. neke procedure, funkcije itd., bez sistemskih schedulera

HA postoji mogucnost ali tek od verzije 5.1.6 :o( kada treba da se ubaci podrska za tzv. evente, bar su tako najavili.
http://dev.mysql.com/tech-resources/articles/event-feature.html


[Ovu poruku je menjao bigguy dana 09.04.2006. u 21:08 GMT+1]
 
Odgovor na temu

[es] :: MySQL :: automatsko pokretanje upita

[ Pregleda: 2213 | Odgovora: 2 ] > FB > Twit

Postavi temu Odgovori

Navigacija
Lista poslednjih: 16, 32, 64, 128 poruka.