Procedure missing

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: David Fuller (DavidFuller_at_discussions.microsoft.com)
Date: 03/01/05


Date: Mon, 28 Feb 2005 16:59:03 -0800

I am trying to execute a job from another job. I read where you can use
sp_startjob to perform this function. However, this function does not exist.
When I run the following from tsql I get an error message

EXEC sp_start_job @job_name = 'Daily Sales Rpt'
Could not find stored procedure 'sp_start_job'.

I am running.
Microsoft SQL Server 2000 - 8.00.818 (Intel X86) May 31 2003 16:08:15
Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT
5.2 (Build 3790: )
Any ideas?



Relevant Pages

  • Version.
    ... or I need to install Service pack? ... Copyright 1988-2005 Microsoft Corporation Standard Edition on Windows ...
    (microsoft.public.sqlserver.clients)
  • Re: SQL2000 w/ SP3 Gatherer Errors & failed population
    ... troubleshooting... ... Copyright 1988-2003 Microsoft Corporation Standard Edition on Windows ...
    (microsoft.public.sqlserver.fulltext)
  • Understanding the LIKE
    ... Copyright 1988-2003 Microsoft Corporation Standard Edition on Windows ... The following returns all records where filefttype is NULL: ...
    (microsoft.public.sqlserver.programming)
  • Windows permissions was Re: Its COBOL, Jim, but not as we know it...
    ... Windows is highly configurable; the fact that people ignore this and run ... One of the problems is also figuring out what security features ... Microsoft email can automatically execute an attachment. ... Here's a transcript from a Linux forum 4 years ago where at least one user ...
    (comp.lang.cobol)
  • Re: Its COBOL, Jim, but not as we know it...
    ... Windows is highly configurable; the fact that people ignore this and run ... It is _you_ that has improved the security, ... Microsoft email can automatically execute an attachment. ... Here's a transcript from a Linux forum 4 years ago where at least one user ...
    (comp.lang.cobol)