Scheduling Tasks to run in a Yii environment

Hello,
I have been lucky enough to have been given an opportunity to work with Yii and PHP using a SQL Server backend. I have developed a number of applications with simple workflow and so far so good. I now require to have programs run that read through the records created by the application to send out reminders, update status information etc.
I was wondering if someone could please give me some direction on how I might go about setting this up. The Yii, PHP environment runs on a Windows 2008 server so I am guessing I can use Windows Scheduler - I have never used this before. Is it just a matter of writing an action in the Controller I wish to run and then pointing a Windows Scheduled task to that URL eg http://......./index.php/myapp/myAppsAction?
My search on the Web directed me to running Cron jobs and even that seemed confusing.

Kind regards
Chris
ChrisMinasAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Ryan ChongBusiness Systems Analyst , ex-Senior Application EngineerCommented:
I got some experience (in fact problem) with my hosting website when I try to call a scheduled task to trigger a php page to send out email notifications.

So, the solution for my case is that the scheduled task will be triggered to call an executable instead (like a vbs, exe, batch file etc), and then let that executable to call the php page accordingly. Looks a bit weird but it works for me!
0
ChrisMinasAuthor Commented:
Thanks for your response Ryan.

Do you have an example of how you wrote the vbs, exe please?

Cheers!

Chris
0
Ryan ChongBusiness Systems Analyst , ex-Senior Application EngineerCommented:
I checked back my site, it's kind of weird stuff.... the scheduler is calling a .bat file which calling a .vbs file.

Samples:

task.bat
CScript C:\Domains\mysite\wwwroot\task.vbs

Open in new window


task.vbs
Call Send_HTTP_Request()
Sub Send_HTTP_Request()
On Error Resume Next
Dim objRequest
Dim URL
Set objRequest = CreateObject("Microsoft.XMLHTTP")
URL = "http://www.yoursite.com/test/yourscript.php"
objRequest.open "POST", URL , false
objRequest.Send
Set objRequest = Nothing
End Sub

Open in new window


You may modify from the sample I provided above.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
PHP

From novice to tech pro — start learning today.