how to place exe file in sql server?

[chidambaram]

hi all,

I am working in VB.NET 2003 version.

I want to run my program in scheduled manner. It have to run once in a day by 5 AM.

I finished my program and created exe file.

how can i schedule this exe file in SQL server?

Thanks in advance..

 

[abohmeed]

Why SQL?

Correct me if I'm wrong, but why do you a need a SQL server for this task? I understand that SQL is used for storing large amounts of relational data.

For your task, i guess the best way to do it is create a windows service with a Timer component that does a check say every 10 minutes to see whether or not the system time is 5:00 AM and if so, it runs your EXE (using System.Diagnostics.Process.Start(Path to your EXE).

Hope this helps