Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

sp_start_job will not work Expand / Collapse
Author
Message
Posted Wednesday, October 14, 2009 11:51 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 1:06 PM
Points: 1,563, Visits: 2,392
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.
Post #802991
Posted Wednesday, October 14, 2009 12:39 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 10:26 AM
Points: 5,871, Visits: 12,971
try EXECUTE msdb.dbo.sp_start_job @job_name = 'Property Schedule'


---------------------------------------------------------------------

Post #803024
Posted Wednesday, October 14, 2009 12:45 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 1:06 PM
Points: 1,563, Visits: 2,392
Thank you George, that worked.

Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
Post #803027
Posted Wednesday, October 14, 2009 12:49 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 10:26 AM
Points: 5,871, Visits: 12,971
pleasure greg. nice truck.

---------------------------------------------------------------------

Post #803029
Posted Thursday, October 15, 2009 12:22 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 1:06 PM
Points: 1,563, Visits: 2,392
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.
Post #803648
Posted Monday, August 5, 2013 6:32 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, August 5, 2013 6:28 PM
Points: 1, 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!
Post #1481128
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse