:discuss:Unfortunately I believe that none of the answers are correct for this question. The answers refer to batches, and use DMV's. The answer to your question would be to read the message field in the sysjobhistory table in msdb in order to get the status of the job. Also, these batch statuses are not in the tables used by the DMV for long making it difficult to get the completion status, unless the absence of an entry equals the completion but that does not tell you if the completion is a success or failure. But you can get the percentage of completion.