SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


sp_start_job will not work


sp_start_job will not work

Author
Message
Greg Snidow
Greg Snidow
SSCrazy
SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)

Group: General Forum Members
Points: 2227 Visits: 2486
Greetings all. I am trying to write a procedure that will run a DTS package. I have found many posts here, many of which point to sp_start_job. So, I scheduled a job, deleted the schedule for it, and am trying to run it by using the below, which is how it is in BOL.


EXECUTE sp_start_job @job_name = 'Property Schedule'



However, when I try to execute this, I get...

Server: Msg 2812, Level 16, State 62, Line 1
Could not find stored procedure 'sp_start_job'.



Is there some configuration I need to set? BOL does not offer much insight for this one. Thanks all.

Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
george sibbald
george sibbald
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10836 Visits: 13687
try EXECUTE msdb.dbo.sp_start_job @job_name = 'Property Schedule'

---------------------------------------------------------------------
Greg Snidow
Greg Snidow
SSCrazy
SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)

Group: General Forum Members
Points: 2227 Visits: 2486
Thank you George, that worked.

Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
george sibbald
george sibbald
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10836 Visits: 13687
pleasure greg. nice truck.

---------------------------------------------------------------------
Greg Snidow
Greg Snidow
SSCrazy
SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)

Group: General Forum Members
Points: 2227 Visits: 2486
Yep, there are many days that I long to be back up in the bucket, splicing copper.

Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
jack.carico
jack.carico
Forum Newbie
Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)

Group: General Forum Members
Points: 9 Visits: 0
Worked for me as well. My job step had defaulted to the master database so it was never going to find it.
Thanks!
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search