June 20, 2003 at 6:11 am
Hi!
Just configured a master server and 10 target servers, made a simple multi-server job, tried to run it, on four of them the "Last run time" and "Last run status" are unknown.
The "Target server status" on three of these servers is "Blocked", on one othem "Offline?"
For those, that are blocked, the "Download instructions page" shows:
Successfully downloaded at 19.06.2003 19:00:01
/*for delete operation*/
Blocking error preventing further downloads: Ad hoc updates to system catalogs are not enabled. The system administrator must reconfigure SQL Server to allow this. [SQLSTATE 42000] (Error 259)
/*for insert operation*/
Not yet downloaded.
/*for insert operation*/
Not yet downloaded.
/*for start operation*/
For the server, that is "Offline?" (it is fully operational, I can "see" it from QA, EM), the "Download instructions page" shows:
Not yet downloaded.
/*for all operations*/
As for "Ad hoc updates to system catalogs are not enabled" does this mean "allow updates"
to be set to '1'?
On all my servers, I have the same setting:
name minimum maximum config_value run_value
----------------------------------- ----------- ----------- ------------ -----------
allow updates 0 1 0 0
June 20, 2003 at 6:53 am
I suggest you to force the pull of the target servers to the master server. To force the pull means that every target server will connect to the master, and check for new instructions to download or jobs execution to report.
You can force it from EM, or also execute from the target server the sp sp_sqlagent_notify with the @op_type = 'P' parameter from the MSDB db.
With that download instruction that is bloked and blocking the others, try clearing from EM and then force a poll.
If it is still blocked, then you will have to deleted and re execute the operation droped.
June 20, 2003 at 8:48 am
When I push "Force poll" button on "Target server status" page, all servers a successfully polled (the "Offline?" one too). When I delete all instructions all "Blocked" servers go to "Ok" status, the "Offline?" one does NOT. When I try to synchronize jobs, all former "Blocked" servers go "Blocked".
The only thing I noticed, is that all problem servers have "lightweight pooling" option set to '0', and only one "good" server has it set to '0' too. There are some differences in "user options", "remote login timeout (s)" and "remote query timeout (s)" on all servers...
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply