Run 2 PHP Scripts Hourly in Windows

anevins

Hi everyone,

I need 2 PHP scripts to run hourly for about 10 days.
I'm using Windows.
One script grabs data from Twitter. The other script pushes that data into my database tables.

I've tried using schtasks and AT command but they don't interact with my database.

I'm looking at using exec function http://php.net/manual/en/function.exec.php .
So, I have an additional third script that holds these exec functions, that executes the 2 scripts.
This sounds good, but then don't I run into the same dilemma of how to run this third script every hour?

Any suggestions are welcome,
Cheers,
Andrew.

dalecosp

Windows BATCH file via Task Scheduler?

anevins

Will the BATCH file allow my scripts to interact with my database? It's just I've created tasks on scheduler before and it doesn't allow this.

Bonesnap

Interaction with your database is dependent on your scripts, doesn't have anything to do with what you use to schedule them.

I have a few scripts running on various schedules. In my Task Scheduler I told it to run the PHP executable and passed the file I wanted as an argument. All my scripts interact with my database without problems.

anevins

Thanks, I'll retry the task scheduling.

anevins

Hmm, I think I remember why I didn't want to use Task scheduler.
I need to run the scripts constantly, sort of in the background for an hour.
With task scheduler, it runs for the scheduled time but then 'completes' and waits until the next scheduled time to run again.

Sorry for not being clear.

bradgrafelman

So then wrap whatever code is currently just "completing" inside of some sort of loop that runs for the desired length of time/iterations.

anevins

Thanks Bradgrafelman, I'll get on with that.

Weedpacket

Um ... why exactly would they need to run "constantly" - especially if they're accessing a web service? And if they are running constantly, what is running hourly?

anevins

Weedpacket;11020965 wrote:
Um ... why exactly would they need to run "constantly" - especially if they're accessing a web service? And if they are running constantly, what is running hourly?

I need them to run constantly in the background so I'm always bringing in tweet from Twitter.
I need to restart them every hour in case the scripts crash, which they do.

Ashley_Sheridan

I've written scripts that pulled in tweets before, I just set them to run every 10-15 minutes regularly, but that can be more frequent if you need. If the scripts are crashing, I'd say you have other problems though. I've never had a problem with CLI PHP scripts, and have written some that run for hours without issue. It is likely that you have some sort of memory problem which needs addressing. Do you get any errors or crash reports?

anevins

I don't get any errors, but:
I've just ran the command ps aux about 7 hours after I started the two scripts, 'get_tweets.php' and 'parse_tweets.php'.
Only one php.5.4.3/php task was running, that was started at the time when I started the scripts. So from this, I believe it represents one of the scripts, but not the other.
I restarted both scripts and now there are two php.5.4.3/php tasks running.

I'm using this Framework by the way http://140dev.com/free-twitter-api-source-code-library/twitter-database-server/install/