You can also schedule a job in SQL Server itself and run it every 2
hours or as needed

Andrian

Mike Kelley wrote:
> 
> Another option is the "at" command
> 
> I don't remember the syntax but from a command window just type in
> at help
> or
> at /?
> or
> at ?
> One of those should get you the help listing which will tell you the
> syntax, on windows the "at command" is the same thing as Cron in Unix
> 
> DoStuff Postmaster wrote:
> 
> > Yes, on a Unix machine you can run a cron job (not sure how to do that
> > since I don't use Unix, maybe someone can fill him in) or on windows
> > 2000 you can insert a new task into the scheduler and just have it
> > link to Internet Explorer and then the web page like this:
> >   C:\Program Files\Internet Explorer\iexplore.exe
> > http://www.yoursite.com/script.php
> >
> > Ruslan Ohitin wrote:
> >
> >> Hi,
> >>
> >> Try to use a scheduler to run command
> >>    php.exe -q x:\path\to\your\script.php
> >> every 2 hours. (-q - do not output HTTP headers)
> >>
> >>
> >> P> Hi,
> >>
> >> P> I am using php4 with mssql backend loaded on windows 2000.
> >>
> >> P> Here is my problem:
> >>
> >> P> I want to update my database contents every 2 hours with some sql
> >> P> statements.
> >> P> Is there anyway I can write scripts in php and run them every 2
> >> hours?
> >> P> Anyother solutions are most welcome.
> >>
> >> P> Thank You,
> >> P> Sagil.
> >>
> >
> 
> --
> "There is a principle which is a bar against all information, which is proof against 
>all arguments and which cannot fail to keep a man in everlasting ignorance - that 
>principle is contempt prior to investigation." - Herbert Spencer
> 
> Michael Kelley
> [EMAIL PROTECTED]
> Programmer/Systems Analyst I
> New Mexico State University
> Information and Communication Technologies
> Work # (505)-646-1374
> P.O. Box 30001
> MSC: 3AT
> Las Cruces, NM 88003
> 
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]

-- 
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to