sp_start_job not in the list - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

sp_start_job not in the list

Author

Topic

karuna
Aged Yak Warrior

582 Posts

Posted - 2007-07-13 : 15:14:14

I'm not able to find sp_start_job under system stored procedures in msdb. If I just run sp_start_job I get execute permission denied. If I run

sp_helptext sp_start_job

I get the below error
The object 'sp_start_job' does not exist in database 'msdb' or is invalid for this operation

I am not sure, what is missing, permission or the system procedure itself is not there?

Thanks
Karunakaran

b.veenings
Yak Posting Veteran

96 Posts

Posted - 2007-07-13 : 15:27:04

usually system stored procedures in the master database..... search there for it.

if not look in the database where it should be running on.

Need an SQLDB consultant?
check www.veeningsengineering.nl

karuna
Aged Yak Warrior

582 Posts

Posted - 2007-07-13 : 15:33:46

quote:
Originally posted by b.veenings

usually system stored procedures in the master database..... search there for it.

I searched in master already, its not there

Thanks
Karunakaran

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2007-07-13 : 15:50:05

[code]
use msdb
exec sp_helptext sp_start_job

[/code]

CODO ERGO SUM

karuna
Aged Yak Warrior

582 Posts

Posted - 2007-07-13 : 15:54:13

quote:
Originally posted by Michael Valentine Jones

use msdb
exec sp_helptext sp_start_job

CODO ERGO SUM

Sorry for not posting more clearly.

I got the errors in the first post of this thread, when I was trying to execute from msdb.

Thanks
Karunakaran

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2007-07-13 : 16:09:59

quote:
Originally posted by karuna

quote:
Originally posted by Michael Valentine Jones

use msdb
exec sp_helptext sp_start_job

CODO ERGO SUM

Sorry for not posting more clearly.

I got the errors in the first post of this thread, when I was trying to execute from msdb.

Thanks
Karunakaran

I saw what you posted, but sp_start_job is in the msdb database. If it isn't there, you have an error.

I don't suppose you actually ran my code did you?

CODO ERGO SUM

karuna
Aged Yak Warrior

582 Posts

Posted - 2007-07-13 : 17:12:27

quote:
Originally posted by Michael Valentine Jones
I saw what you posted, but sp_start_job is in the msdb database. If it isn't there, you have an error.

I don't suppose you actually ran my code did you?

CODO ERGO SUM

You are right, I did not run, when I posted the earlier reply. Because I believe that USE msdb and selecting the database in the SSMS are equivalent.

I did ran it now, and got the same error. Below is the exact error I got.

quote:

Msg 15009, Level 16, State 1, Procedure sp_helptext, Line 54
The object 'sp_start_job' does not exist in database 'msdb' or is invalid for this operation.

It looks like either my sql installation is wrong, something was not installed.

Thanks
Karunakaran

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2007-07-13 : 17:55:26

Maybe the procedure was dropped or renamed.

What version and edition of SQL Server are you running?

CODO ERGO SUM

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-07-13 : 18:13:26

What kind of permission do you have in msdb?

karuna
Aged Yak Warrior

582 Posts

Posted - 2007-07-13 : 18:17:38

quote:
Originally posted by Michael Valentine Jones

What version and edition of SQL Server are you running?

Result of SELECT @@VERSION
Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86)
Feb 9 2007 22:47:07
Copyright (c) 1988-2005 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

quote:
Originally posted by Michael Valentine Jones

Maybe the procedure was dropped or renamed.

Well, since I see a bunch of other system stored procedures, I did not think this proc might be dropped or renamed. I have to check with DBA.

Thanks
Karunakaran

karuna
Aged Yak Warrior

582 Posts

Posted - 2007-07-13 : 18:24:07

quote:
Originally posted by rmiao

What kind of permission do you have in msdb?

I guess public, need to find out from DBA.
In the Security\Logins node under my see only one database selected. The master,msdb,temp all are unchecked for the MAP column.

Thanks
Karunakaran

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources