Perry Whittle

Perry Whittle

  • 1.7k
  • 4
  • 79

check and wait for sql agent job status smo c#

Oct 15 2024 12:26 PM

Hi

im launching a dsql agent job via SMO JobServer.Jobs class and issuing job.Start() which works fine.

I then want to wait in a loop updating a textbox or label or something and inside the loop im checking the jobexecutionstatus is executing.

The problem is it just launches the job and never waits, has anybody else doen similar to this and can help please