How to know when a job finishes?

L

Luis E Valencia

Dim backUpDB2 As SqlClient.SqlCommand

backUpDB2 = New SqlClient.SqlCommand

backUpDB2.CommandType = CommandType.StoredProcedure

backUpDB2.CommandText = "msdb.dbo.SP_RESUMENFAC"

backUpDB2.Connection = SqlConnection1

backUpDB2.ExecuteNonQuery()





I have this sp that starts a JOB that takes 1 minute to finish. This job
takes information form an as400 system to the sql server database. and then
I fill some datagrid with the UPDATED INFORMATION but this iis not
happening. Because the sp only starts the job, I need to know when it has
finished to show the updated data,


Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,769
Messages
2,569,579
Members
45,053
Latest member
BrodieSola

Latest Threads

Top