MS SQL 2000 : How to invoke/start a scheduled SQL job via stored procedure?
Posted on 2007-11-25
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.