How can I run a scheduled job from within store procedure

[Ali Alhussein]

hi, want to create a job to run when some changes happend in a table. I thought of creating the job in job folder under sql server agent. I could not figure out how to call this job from within store procedure or from a trigger when a value of a field changes.

Any help in this. thanks alot

Ali

[Gary Andrews]

Run sp_start_job


------------
Ali Alhussein at 7/31/01 4:44:00 PM


hi, want to create a job to run when some changes happend in a table. I thought of creating the job in job folder under sql server agent. I could not figure out how to call this job from within store procedure or from a trigger when a value of a field changes.

Any help in this. thanks alot

Ali