BizTalk360 uses sp_help_job stored procedure from MSDB database to get the jobs running in the SQL instance. Following permission setting will help to get the SQL jobs.


If you are using SQL Server 2005/2008 R2, this information will help.


By default, members of the sysadmin fixed server role can execute this stored procedure. Other users must be granted SQLAgentReaderRole fixed database roles in the msdb database.