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

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.