sp_start_job

From: simon (simon.zupan_at_stud-moderna.si)
Date: 09/27/04 

Date: Mon, 27 Sep 2004 14:32:38 +0200

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: Differences in execution times for a stored procedure
    ... If OleDb, ... "Vincent Keller" wrote:> I am trying to execute a time-consuming stored procedure in my application. ... > Are there some known performance differences in executing a query directly through Query Analyzer and through ADO.NET? ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: check for duplicate data using stored procedure
    ... >>why i whatever procedure name i put, then the error message will show ... > executing the script that creates the stored procedure more than once. ... you can simply use EXECUTE to ... using sql mail to the user when i found that the rd_awards table have ...
    (microsoft.public.sqlserver.programming)
  • Differences in execution times for a stored procedure
    ... I am trying to execute a time-consuming stored procedure in my application. ... When I run the stored procedure through Query Analyzer, ... Are there some known performance differences in executing a query (stored ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: ADO, SQLServer2000 and errors
    ... "Luigi" wrote in message ... > If I execute the stored procedure in Query Analyzer what happens, ...
    (microsoft.public.data.ado)
  • Re: Return Code from Stored Proc
    ... > in order to get a return code, I believe you need to use execute Scalar ... the return from ExecuteNonQuery is NOT the stored procedure return ... From SqlClient the error message will ... appear as a SqlException and you can examine it in your catch block. ...
    (microsoft.public.sqlserver.programming)
Loading