March 15, 2017 at 9:55 pm
Good Day i have a problem relating to the calling of a SPROC in a sql server agent job. When i create a job on its own everything works just fine however it it is included as part of a Job with mulitple steps before it The call fails with the following
recorded in the errorlog
03/16/2017 12:22:00,spid56,Unknown,Configuration option 'Agent XPs' changed from 0 to 1. Run the RECONFIGURE statement to install.
Any help would be greatly appreciated
March 16, 2017 at 4:23 am
Hi,
it would be easier, if you show us what the job steps will do.
Best regards,
Andreas
March 16, 2017 at 7:35 am
wilhelm.erx - Wednesday, March 15, 2017 9:55 PMGood Day i have a problem relating to the calling of a SPROC in a sql server agent job. When i create a job on its own everything works just fine however it it is included as part of a Job with mulitple steps before it The call fails with the following
recorded in the errorlog03/16/2017 12:22:00,spid56,Unknown,Configuration option 'Agent XPs' changed from 0 to 1. Run the RECONFIGURE statement to install.
Any help would be greatly appreciated
Are you seeing this in the SQL Server error log? That is logging of the configuration change, either by executing sp_configure or by starting SQL Agent.
Sue
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply