Recently I was running some tests on the scheduler code in one of our home-grown applications and needed to check that
the job schedule set up by our software exactly matched the details held in SQL Server Management Studio (SSMS).
Now this code has been run and tested many times before without problems in SSMS and has been meticulously hand-tested.
Yet on this occasion, I opened up a job I had just created to find there was no entry in the Job window for its name, the
category into which it had been created or certainly any details in the Steps or Schedules pages.
My first reaction was that something was wrong with the code. I opened up another job to find the same problem. All job
properties were absent. I raced through another half dozen jobs to find that they were all showing blank entries. This
was on my local development machine, so I connected to another test server to see if it was local to me. Nope. I found
the same problem again on the test server.
I opened up the Job Activity Monitor window and saw a list of all my jobs. Double-clicking to open up the Job Properties
window showed all the details of the job, exactly as specified by the application.
Interestingly I eventually noticed that when I clicked on a job under the Jobs folder of SQL Server Agent in Management
Studio, instead of opening the Job Properties window, it opened a New Job window. I guess this explains why all my job
details disappeared. The progress bar at the bottom left hand corner of the window also showed an error occurred.
Ok, so some consolation that this was a Microsoft coding error, not one of ours. Just to prove it was Microsoft at fault
and not our code, I also ran: |