Re: SQL Server Agent - Job Step (CmdExec) doesn't work

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 08/17/04 

Date: Tue, 17 Aug 2004 13:17:36 +0200

You need to find a way to suppress that dialog. Services cannot do windows GUI output, nor can they
have any user input. 

-- 
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"angus" <angus@angus.com> wrote in message news:%23UVVNnEhEHA.632@TK2MSFTNGP12.phx.gbl...
> Hi greybeard,
>
> To make my word simple,
>
> I have an exe console program which is written by using vb.net
>
> That program has imported a custom dll as reference
>
> that program cannot be run in cmdExec job step, as there is a debugger
> prompt out and show my the my custom dll cannot be referenced.
>
> Thank you.
>
>
>
> "greybeard" <vlastik.bartos@senior.cz> wrote in message
> news:O9rjchEhEHA.3388@TK2MSFTNGP09.phx.gbl...
> > Sorry, I don't understand, what are you doing. But:
> >
> > if you are trying to exec a program by standard SQL jobs, it runs at
> server
> > context (probably without a user) so it has no screen and this can be why
> it
> > hangs.
> >
> > If I'm out of problem, sorry :-)
> >
> > Vlastik
> >
> > "angus" <angus@angus.com> píše v diskusním příspěvku
> > news:u9vnSPEhEHA.3236@TK2MSFTNGP10.phx.gbl...
> > > Dear All,
> > >
> > > I have tried to use the cmdexec in job step with a simple exe program,
> it
> > > works fine,
> > >
> > > however, when i need to run an exe program, which has imported other
> dll,
> > it
> > > fails.
> > >
> > > My related files are
> > >
> > > C:\Inetpub\wwwroot\Invoice\bin\base.dll <- my own dll class
> > > C:\Inetpub\wwwroot\Invoice\bin\Invoice.exe <- my exe program that
> imported
> > > base.dll
> > >
> > > I have tried to run "C:\Inetpub\wwwroot\Invoice\bin\Invoice.exe" in
> > command
> > > prompt (cmd.exe)
> > >
> > > It works fine, however, when i assign this exec in "CmdExec" job step,
> > >
> > > (Command in the Job Step: C:\Inetpub\wwwroot\Invoice\bin\Invoice.exe)
> > >
> > > once the schedule has been fired up, a debugger prompted out, program
> > > halted, job failed. it seems that the
> > > scheduler cannot import the base.dll
> > >
> > > What i can do?
> > >
> > > Thank you for your advices.
> > >
> > > Regards,
> > > Angus
> > >
> > >
> >
> >
>
>

Relevant Pages

  • Re: Prevent Commands in SQL Update
    ... I am not familiar with PHP, but ADO is ADO ... ... sinple way to clean an SQL statement. ... Server-side validation of ALL user input MUST be done, ...
    (microsoft.public.data.ado)
  • Re: Complex? Finding both Fields using a parameter with either or
    ... I can now reference just that single User Input field on the report Header. ... I have a slight problem with the SQL. ... If it can't be done in a query, ...
    (microsoft.public.access.queries)
  • Re: Is sql-injection possible in following code
    ... is it necessary to be vulnerable for sqlinjection procedure must use some Dynamic SQL statements using execute immediate ??? ... If the values are being generated from user input, ... CREATE OR REPLACE PROCEDURE demo(MyID IN VARCHAR2) ... Securing Apache Web Server with thawte Digital Certificate ...
    (Security-Basics)
  • encrypting the sa password
    ... The DBA here changed the sa password and now a .exe program that users ... double-click on in order to run a SQL 2000 DTS package gives the response ... how can I encrypt the new sa password into this app.config file. ... SQL Programmer ...
    (microsoft.public.vstudio.development)
  • Re: ASP vbscript if statement acting strange
    ... "sql" variable as soon as it comes out of the condition. ... it doesnt write anything.As if the variable doesnt ... When I have a response.write inside the first condition, ...
    (microsoft.public.inetserver.asp.db)