Re: sp_start_job

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 09/27/04 

Date: Mon, 27 Sep 2004 14:43:51 +0200

The proc is in msdb:

EXEC msdb.dbo.sp_start_job @job_name = 'prenosZaCPO' 

-- 
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"simon" <simon.zupan@stud-moderna.si> wrote in message news:OgpNV4IpEHA.1308@TK2MSFTNGP14.phx.gbl...
> If I would like to execute the job from query analyzer:
>
> EXEC sp_start_job @job_name = 'prenosZaCPO'
>
> I get an error message:
>
> Server: Msg 2812, Level 16, State 62, Line 3
> Could not find stored procedure 'sp_start_job'.
>
> Why?
>
> The 'sp_start_job' exists in extended SP in master db.
>
> If I execute the same sp_start_job  from some other database, it's ok.
>
> Thank you,
> Simon
>
>

Relevant Pages

  • Re: 64bit insert delays
    ... If you execute them in QA using the same QA window, then they are executed synchronously, i.e., the ... Tibor Karaszi, SQL Server MVP ... >> If that takes significant time, then you have some other problem. ... >> Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: Question about performance of an update statement
    ... > "Learner" wrote in message ... >> 1) Shoudl there be any performance difference if I execute the above ... >> update statement from Query Analyzer or via a DTS ...
    (microsoft.public.sqlserver.programming)
  • Re: Trying to Execute a file using exec master.dbo.xp_cmdshell, from ASP
    ... You're running it in Query Analyzer as YOU, however the ASP page is likely ... I have this file I need to execute from an ASP client. ... > usr/ProfileXXX YYY from the command. ...
    (microsoft.public.inetserver.asp.general)
  • Re: Error for a job that uses a MSDASQL linked server
    ... Tibor Karaszi, SQL Server MVP ... actual job owner? ... >>>>> When I execute the job I have had this error for the step ...
    (microsoft.public.sqlserver.server)
  • Re: STored Procedures and results ets
    ... Tibor Karaszi, SQL Server MVP ... "Lawrence" wrote in message ... >> Use SET FMTONLY ON and execute the proc. ... >> Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.programming)