How to Query a sql job

[JC]

I start a job on sql server via sp_start_job, i then need to wait until that
job completes and run some other jobs, how can i get the job history from
this job via a stored proc in c#.

jc

 

[Doug Perkes]

JC,

All job histories are stored in the MSDB.dbo.syshobhistory table. You can
query that database and check the run_status field to determine if the job
has completed or failed.

HTH,

Doug Perkes