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.
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.