[Resolved] Automated SQL

JJ123

I am writing a PHP/MS SQL tool that users can use to submit tickets to out IT team. Once they do this, the ticket will go into a queue.

I want to be able to send an e-mail notification to two managers if the ticket status is not changed within 15 minutes of it being logged. I am capturing the time that the ticket is submitted but I don't know how to handle the time thing.

What can I use to determine if 15 minutes have gone by automatically?

tasistro

Setup a cron job every minute or 5 minutes to check the status.

JJ123

Sory but I am still new at this...

What is a cron job. Is that something on the SQL server?

JJ123

Okay - so I have been reading about CRONs Jobs. I am running PHP on a Windows box using IIS and MS SQL.

So I could possibly use Task Scheduler according to the documentation that I have read. But I am not sure how to run a PHP script within the scheduler.

I have been trying to get this to work and I don't know how to select the php file. It gives you a list of apps that you can run and IE is one of them but I can't specify a page for it to go to.

How can I get around this?

stolzyboy

i know you can do it with an asp page that you have to convert into vb and have the task scheduler run that, but it can't simply run a page and execute it, it has to be a program, hence the vb,

you may be able to write a dll executable with vb and have that call IE which calls the php page, which you can then call with task scheduler, but this is a far stretch

JJ123

Can you write me a quick example in ASP? or VB?

stolzyboy

i personally haven't done this, my boss does this all the time, and i don't think he would be willing to spend his time on this for php, he is kinda a M$ head, sorry, you can search on google/yahoo for this

JJ123

Okay - thanks anyway. I will start searching then...