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.