How To Know When A Job Has Finished. For Experts I Think.,

I have this on my page


Dim backUpDB2 As SqlClient.SqlCommand


backUpDB2 = New SqlClient.SqlCommand


backUpDB2.CommandType = CommandType.StoredProcedure


backUpDB2.CommandText = "msdb.dbo.SP_RESUMENFAC"


backUpDB2.Connection = SqlConnection1


backUpDB2.ExecuteNonQuery()








The SP has this





CREATE PROCEDURE .[SP_RESUMENFAC] AS





EXEC sp_start_job @job_name = 'TransferirDatos(FACT) '





GO





WHen I execute the page after the SP it fills some datagrid but the data is not updated bacuase the job takes 1 minute or more to finish.





Is there anyway to prevent to show the old data? or to detect when the job has finished?





Thanks