Testing "Batch" Status

[FaStOnE]

Is there a way to test for a job submitted by "msdb.dbo.sp_start_job" for completion? I kick off a Bulk Insert job that can run for 10-30 seconds. But, I need to process the result table in the next step. How can I monitor the job to test for the completed status so that I can continue with the next job step?

Thanks for your help!!

Rick

 

[clapag22]

Have you checked out SYSJOBS and SYSJOBSTEPS? They are tables in the MSDB DB that have a lot of job related info...

Or how about this... Have the last step in this job insert a row into a table and your process loops until this table has the data in it that says you can continue...