November 16, 2004 at 6:11 am
I am seeing a problem this morning when I create a maintenance plan. After creating the plan the "job" does not appear. The maintenance plan does. Has anyone seen this? I have verified that a schedule is set in the plan and I have refreshed EM.
November 16, 2004 at 9:06 am
I have not seen this before. But at this point you can try the following:
(1) try to create a job and see if it works.
(2) look for any errors in Errorlog and event viewer.
(3) try to reboot the server.
If after reboot still doesn't work, try to run DBCC CHECKDB and then CHECKALLOC on MSDB to see if there are any errors. If no errors, and nobody else can give you a fix for this, then I don't know what else to do other than calling Microsoft.
November 16, 2004 at 10:51 am
When you say, u scheduled the job, did u wait for the job to run? Because I think once you create the maintenance plan, it has to run at least once to create that job.
taj
Tajammal Butt
November 16, 2004 at 12:20 pm
Well, I am not real sure what was going on but a reboot seems to have fixed everything. very very strange.
November 16, 2004 at 1:02 pm
Did you try Actions ->Refresh when SQL Server Agent is highlighed in the left pane of Enterprise manager?
Or Disconnect and Connect again when a particular SQL Server is highlighted in the Enterprise Manager?
I some cases changes are not reflected in Enterprise Manager until you refresh or until you disconnect and connect again. It does not mean the job was not created. It probably was which could be proven by "select * from msdb.dbo.sysjobs". And yes, reboot will certainly refresh the connection so the job become visible
Yelena
Regards,Yelena Varsha
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply