I want to run an agent job from a batch file, but I want the batch file to run until the job is finished.
Currently, I'm using sp_start_job, and that returns whether the job started. - not what I'm lookin for. I want to know if the job succeeded or failed. In most cases I'd use sp_help_job but not sure how to do that with a batch file.
How can I achieve the desired result of having the batch file run until success or failure?
Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.