Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Execute job from stored procedure? 1

Status
Not open for further replies.
tcstom

tcstom

Programmer
Joined
Aug 22, 2003
Messages
235
Location
GB
Hi,

I want to execute a SQL Agent job from a stored procedure in SQL Server 2000. Is this possible? If so, how can I do it?

Thanks.
 
Sort by date Sort by votes
Check out sp_start_job in BOL.

--John [rainbow]
-----------------------------------
Behold! As a wild ass in the desert
go forth I to do my work.
--Gurnie Hallock (Dune)
 
Upvote 0 Downvote
Thanks JohnDTampaBay. I'd heard of that SP but didn't realise it had to be executed using the msdb database. Thanks again.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

bharons
  • Locked
  • Question Question
Pick up value from combobox
Replies
0
Views
780
bharons
bharons
grnzbra
  • Locked
  • Question Question
GOING FROM DD/MM/YYYY TO MM/DD/YYYY
Replies
4
Views
1K
JeffModen
JeffModen
Auguy
  • Locked
  • Question Question
Move From SQL 2014 Express To Newer Version
Replies
2
Views
387
Auguy
Auguy
BeatriceC
  • Locked
  • Question Question
SQL Linked server StoredProcefure job creates temp files
Replies
1
Views
375
pjw001
pjw001
eboughey1008
  • Locked
  • Question Question
Import columns from one table into another table with dissimilar field layout
Replies
7
Views
620
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top