Schedule jobs

I need to schedule a task which would get the data from mysql, convert as excel file and then create a file in my local system (or) remote system in C: (or) D: drive & as well as send email with attachment.

I have written script and it works fine. I have scheduled the job in timer component in the header page which will run every one hour. The problem which i am facing is i need to login to the project and keep it open, for the timer component to work.

How do i make the timer to invoke automatically without opening the project.

Do i have any alternative way of scheduling the task.


Gateway Scripts run all the gateway without the need to log on.