running a vb .net exe as a sql agent job

[Bernie Yaeger]

I'm primarily a vb .net developer, doubling (as many of us have to) as a sql
2000 dba.

I'm having difficulty running a vb.net exe as a sql agent job. I figured
out that sql 2000 can't really run a windows forms exe, as it thinks it
needs user interaction. However, since it can run an activex script, can it
also run a windows service produced in visual studio 2003?

Thanks for any help.

Bernie Yaeger

[Bernie Yaeger]

Hi Dave,

Tx for the response. I figured it out - right, a windows service fails, but
a console app runs fine.

Thanks again,

Bernie

"David Williams" <Da***********@ discussions.mic rosoft.com> wrote in message
news:35******** *************** ***********@mic rosoft.com...

I would not think that you would run a windows service (written in any language) from a SQL Agent job. A windows service is normally run by the
operating system as a "background " application, and is (normally) run under
a seperate user. In all cases it is a separate session - meaning of course
that the user that the service runs under logs into the system and runs the
service. It does not run in the interactive users environment at all.
You should be able to run a console application however.
--
David Williams, VB.NET MVP
"Bernie Yaeger" wrote:

I'm primarily a vb .net developer, doubling (as many of us have to) as a sql 2000 dba.

I'm having difficulty running a vb.net exe as a sql agent job. I figured out that sql 2000 can't really run a windows forms exe, as it thinks it
needs user interaction. However, since it can run an activex script, can it also run a windows service produced in visual studio 2003?

Thanks for any help.

Bernie Yaeger