SQLTeam.com | Weblogs | Forums

Polling and determine the status of a job?


#1

Hi,

‌I want to get a message from a RemoteServer when a certain SQL job is successfully terminated. After the job is finished, I want to access this data remotely. This should be done immediately after the job is finished. (While Loop with EXEC msdb.dbo.sp_help_job, OR MessageQueue OR ...?)
SQL2016 to SQL2008R2

Regards
Nicole