I don't want to go off-topic but..

Upgrade scripts, Data-Tier Applications plus numerous other approaches

Look at the heirarchy data type - If you use that can, I seem to remember you can get that info very quickly

Many thanks

Always helpful

Cheers

Thanks for the responses but maybe I didn't explain my situation very well.

I am currently running the global traceflags 1204 & 1222 which give the nodes involved and all...

Thanks - It was for a search form that did not worry about dirty data

Already mentioned SP_HELP_JOB with the parameters but also worth looking at :

SP_HELP_JOBACTIVITY

SP_HELP_JOBHISTORY

🙂

You could add the date parameters into the Xp_readerrorlog stmt if you wish to limit the initial result set?

Many thanks for your prompt response.

Hi there - apologies for the lateness of the response.

There are numerous software packages out there that will notify you on the basis of evt log messages or if...

No worries, not an issue.

I find SSIS a useful tool for various different reasons incl. graphical interface for the devt env, ease of deployment with use of the manifest file...

Sorry Jeff - I was anticipating using a script task from within SSIS to get the info that you were after. It should be a relatively easy script that...

Many thanks for your responses - I am not in the office for a while but I will check as soon as I return.

I may be being thick but the error that you are getting states that the XML is not well formed. Put a try..catch block to eliminate the badly formed XML....

Check the Evt system log - It stipulates the user that sends the stop and start control for the service.

SSIS?