Solved

How do I call a web page in the Unix cron?

Posted on 2007-11-21
5
1,048 Views
Last Modified: 2013-12-26
I have a web page that performs some sql statements against a database. All I have to do to perform the operations is go to http://mydomain.com/sqlop.php?param1=123&param2=xyz. There's no user intervention needed, the page just does it. How do I call this web page from the cron so it calls it on a scheduled basis?
0
Comment
Question by:bemara57
5 Comments
 
LVL 2

Assisted Solution

by:overflow34
overflow34 earned 50 total points
Comment Utility
http://forum.powweb.com/archive/index.php/t-13524.html

Try this link.  I think this is what you are looking for.
0
 
LVL 21

Accepted Solution

by:
robocat earned 200 total points
Comment Utility
The GNU wget utility will do this

http://www.gnu.org/software/wget/

Install and then put this command like this  in your cron

wget -O /tmp/out.txt  "http://mydomain.com/sqlop.php?param1=123&param2=xyz"

0
 
LVL 61

Expert Comment

by:gheist
Comment Utility
Why don't you schedule SQL statements from cron script? Fetching webpage introduces more moving parts in machine.
0
 
LVL 40

Assisted Solution

by:omarfarid
omarfarid earned 200 total points
Comment Utility
Hi,

You may use wget as a crontab job to check your web page. You may have a script like the following, call it checkmypage

cd /path/to/mydir
/path/to/wget www.mydomain.com
if test $? -eq 0
then
.
.
.
else
.
.
.
fi

The above script checks for the exit status of wget ($?)
I left the two sections with dots so that you put your own commands when successful or failure.

The script can be made executable and run as ccrontab job:

crontab -l > mycrontab

add the line below to mycrontab

0,10,20,30,40,50  * * * * /path/to/checkmypage

resubmit your cronjobs

crontab mycrontab

0
 
LVL 1

Assisted Solution

by:estrelow
estrelow earned 50 total points
Comment Utility
An alternative to wget is using lwp-request.
Just set:

lwp-request http://mydomain.com/sqlop.php?param1=123&param2=xyz
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

Suggested Solutions

Introduction: Hints for the grid button.  Nested classes, templated collections.  Squash that darned bug! Continuing from the sixth article about sudoku.   Open the project in visual studio. First we will finish with the SUD_SETVALUE messa…
Using libpcap/Jpcap to capture and send packets on Solaris version (10/11) Library used: 1.      Libpcap (http://www.tcpdump.org) Version 1.2 2.      Jpcap(http://netresearch.ics.uci.edu/kfujii/Jpcap/doc/index.html) Version 0.6 Prerequisite: 1.      GCC …
Learn how to get help with Linux/Unix bash shell commands. Use help to read help documents for built in bash shell commands.: Use man to interface with the online reference manuals for shell commands.: Use man to search man pages for unknown command…
In a previous video, we went over how to export a DynamoDB table into Amazon S3.  In this video, we show how to load the export from S3 into a DynamoDB table.

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now