MS SQL 2000 : How to invoke/start a scheduled SQL job via stored procedure?


I have a scheduled job being created in SQL job scheduler (in Enterprise Manager, it is under Management->SQL server agent->Job).  This job (contains many many steps) needs to be run under schedule.  However, it also need to run under user request.

For the scheduled one, no problem.  But for the user request one, we really don't want to duplicate the same set into a stored procedure as this job has many dependences and will notify operator via  email.  As a result, put it again under stored procedure and to do the same will not be a good idea.  My question is : are there any ways to invoke/start the scheduled job manually via stored procedure ?  (I will make this command as a table trigger)

Thanks a lot.

Who is Participating?
Ken SelviaConnect With a Mentor RetiredCommented:

exec msdb..sp_start_job @job_name = 'Job Name'

Ken SelviaRetiredCommented:
Also, you might take a look at this

for more info about using that in a trigger.
StanleyLMWAuthor Commented:
Thanks a lot.  It works.  Cheers!  ^_^
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.