Take a look at the sp_start_job system stored procedure. This assumes that the job already exists and you only want to start it on demand. Pay attention to the permission requirements. If the login is not a member of the sysadmin role, he/she will only be able to start jobs that they own.
Another option would be to use SQL-DMO. Specifically the Invoke() method of the Job object.
-Mike
>I would like to be able to have a user fire off a SQL job from our VFP app by pressing a button when needed. The job requires taking data from a VFP table and transforming it to SQL format and appending it to the SQL table. I have the job created, however, I am not sure how to code the VFP button to fire off the job when the user needs to have the job ran instead of myself manually starting the job from the EM. Any suggestions?
>
>Thanks in advance
>Kelly