is there in my sql something like a DTS in sql server?

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
pelegk2
Forum Regular
Posts: 633
Joined: Thu Nov 27, 2003 5:02 am
Location: Israel - the best place to live in after heaven
Contact:

is there in my sql something like a DTS in sql server?

Post by pelegk2 »

its a set of function's that u write and the sql server executes them at night
User avatar
Weirdan
Moderator
Posts: 5978
Joined: Mon Nov 03, 2003 6:13 pm
Location: Odessa, Ukraine

Post by Weirdan »

No. But you can use cron and php to send the commands to mysql server at specified time.
User avatar
JAM
DevNet Resident
Posts: 2101
Joined: Fri Aug 08, 2003 6:53 pm
Location: Sweden
Contact:

Post by JAM »

is there in my sql something like a DTS in sql server?
Yes, depends on what sql server you are talking about.
User avatar
pelegk2
Forum Regular
Posts: 633
Joined: Thu Nov 27, 2003 5:02 am
Location: Israel - the best place to live in after heaven
Contact:

hi

Post by pelegk2 »

to "Weirdan" : how do i do that?to run a php at a specified time?does it mean to leave the browser always open?

to "JAM" : i am using a mysql server-is there a dts there?
User avatar
JAM
DevNet Resident
Posts: 2101
Joined: Fri Aug 08, 2003 6:53 pm
Location: Sweden
Contact:

Post by JAM »

Ah, then no, as weirdan said.
A cron-job is a background process in *nix enviroment. You do not need the browser to be opened, this is done automaticly on a given time(s) depending on setup.

http://esm2.imt-mrs.fr/~staffelb/guide_ ... /cron.html
http://forums.devshed.com/t20352/s.html
...is just some examples on how to achieve this. If you are using a win32 platform, there are a windows port of cron available (use this forum's seach to find it).
User avatar
pelegk2
Forum Regular
Posts: 633
Joined: Thu Nov 27, 2003 5:02 am
Location: Israel - the best place to live in after heaven
Contact:

thanks alot

Post by pelegk2 »

:lol:
Post Reply