S
Steve
Is there a way to connect to SQL server and read all of the jobs listed in the job agent and get the status of each job?
I want to create either a web page or a winForm, have a list of all SQL DB servers in a drop down, select the db name, then show a list of all the jobs in the job agent and show the status of each job, (failed, running, succeeded, etc) and the last time the job ran and by who.
is this possible to do and if so how can i get started with something like this?
I want to create either a web page or a winForm, have a list of all SQL DB servers in a drop down, select the db name, then show a list of all the jobs in the job agent and show the status of each job, (failed, running, succeeded, etc) and the last time the job ran and by who.
is this possible to do and if so how can i get started with something like this?