Re: sp_start_job : Launching external apps

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 05/19/04 

Date: Wed, 19 May 2004 23:32:03 +0200

Is it classic VB? Is it compiled with the "unattended execution" option (whatever the option is actually
named)? Does Agent's service account have appropriate permissions? Do you have any errorlogging in your app in
order to determine if something goes wrong? 

-- 
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Steve" <sfuentes@caribe.net> wrote in message news:9ECC6477-94BE-43CE-8B20-3C6256801A7A@microsoft.com...
> I'm not displaying a GUI window. All I'm doing is running a app that creates a flat file. Could there be any
other possible reasons for not executing the app even though the job executes successfully?
>
> Thanks.
>
>      ----- Tibor Karaszi wrote: -----
>
>      Jobs are execute by SQL Server agent. SQL Server Agent is a service. A service cannot display any GUI
windows
>      (it doesn't have a desktop context). Perhaps this is the cause?
>
>      -- 
>      Tibor Karaszi, SQL Server MVP
>      http://www.karaszi.com/sqlserver/default.asp
>      http://www.solidqualitylearning.com/
>
>
>      "Steve" <sfuentes@caribe.net> wrote in message
news:3DE35421-36CB-4372-AB27-0670C23C3CBD@microsoft.com...
>      > I'm trying to launch a VB application from a job I created. When I execute the job, I'm informed that
the
>      job is processed successfully, but my app isn't launched. Any help will be appreciated.
>      >> TIA
>
>
>

Relevant Pages

  • Re: DTS and MSDE
    ... that does the calling of the package as the package runs from the place calling ... I will presume that the package is stored on a SQL Server somewhere. ... The above error is not appearing the in the vb app (removed error ... I've even used the "sa" login to execute the dts pkg and still ...
    (microsoft.public.sqlserver.dts)
  • Requested Registry Access is Not Allowed
    ... We have several applications that will be executing on multiple machines. ... will execute the apps. ... There are Permission Sets within the framework configuration tool, ... The app fails on the WriteEntry and the exception that is thrown is ...
    (microsoft.public.dotnet.framework)
  • RE: Requested Registry Access is Not Allowed
    ... > We have several applications that will be executing on multiple machines. ... > will execute the apps. ... > There are Permission Sets within the framework configuration tool, ... > machine that the app will run. ...
    (microsoft.public.dotnet.framework)
  • Re: disable double clicking attachments
    ... Double click a file and the app opens. ... There's no prompt to save it before the default action takes place. ... It does once you flag their attachment directory as deny execute. ...
    (microsoft.public.outlook.general)
  • Re: Auditing SP Execute.
    ... > As long as the users only have execute permissions on the proc i.e. they ... This assumes that the app doesn't use a single ... > Jasper Smith (SQL Server MVP) ... >> particular sp was execute and by whom. ...
    (microsoft.public.sqlserver.security)