I am trying to find a way to execute a maintenance job from script and have it return if the the job was successful or not. I know that I can use msdb.dbo.sp_start_job to execute the maintenance job, but it will only kick it off with out returning if it was successful or not.
My ultimate goal for this is we use JAMS for all our job scheduling and we want to only need to check there for any job failures.
Aucun commentaire:
Enregistrer un commentaire