SQL SERVER 2K JOB setup question
[88 byte] By [Matrix.net] at [2007-11-11 10:26:27] 
can I write up an ASP.net application and have it executed by a Job in sql server 2000 ?
# 1 Re: SQL SERVER 2K JOB setup question
Web apps are typically (user) interactive. Why would you want a SQL Job to try and launch the app in a web browser?pclement at 2007-11-11 23:43:15 >
# 2 Re: SQL SERVER 2K JOB setup question
well because it would be easier for me to code what I need to happen in .net than in t-sql . I'm not just interested in asp.net but also wondering if it can be done in vb.net and then just have the job set off the windows application which really would just run an single algorythmMatrix.net at 2007-11-11 23:44:20 >
# 3 Re: SQL SERVER 2K JOB setup question
So why not just write the code as a VB.NET app? Is there a reason why you need to launch it from an SQL job?pclement at 2007-11-11 23:45:19 >
# 4 Re: SQL SERVER 2K JOB setup question
So why not just write the code as a VB.NET app? Is there a reason why you need to launch it from an SQL job?simply because I need it to execute by itself on a set schedule and I havent been able to find clear instructions on as to how to write a vbscript to run on a set schedule.
Matrix.net at 2007-11-11 23:46:21 >
# 5 Re: SQL SERVER 2K JOB setup question
You may run any executable as a step in a SQL job: http://msdn2.microsoft.com/en-us/library/ms187056.aspx . I would create a console application in VB.NET, then call it from the SQL job. You may also run the app as a Windows scheduled task, rather than as a SQL job.Phil Weber at 2007-11-11 23:47:20 >
# 6 Re: SQL SERVER 2K JOB setup question
I would run it from the Windows Task Scheduler as Phil mentioned. You could also create a Windows Service and have the code execute at specified intervals.pclement at 2007-11-11 23:48:30 >
