running a vb .net exe as a sql agent job

  • Thread starter Thread starter Bernie Yaeger
  • Start date Start date
B

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
 
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 said:
I would not think that you would run a windows service (written in any
Click to expand...
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.
 
Back
Top