Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
New Member

SQL Server Agent Scheduled Job Failure

I am getting the follwing event error:

SQL Server Scheduled Job 'Optimizations for CIPT' (0xEC47CEE556670F45A39E043AC14288C0) - Status: Failed - Invoked on: 4/8/2002 1:00:01 AM - Message: The job failed. The Job was invoked by Schedule 5 (Schedule 1). The last step to run was step 2 (Optimize Config DB).

Upon further inspection in SQL Manager, it seems that this job succesfully completes optimization of the CDR db, but consistently failes when it tries to optimize the config db. This error is on my subscriber. Anyone have any ideas what is causing this?

1 REPLY
Silver

Re: SQL Server Agent Scheduled Job Failure

Check over the following link:

http://www.cisco.com/warp/public/788/AVVID/CCM_eventlogs.html#SQLserverjobfailed

Sounds like it’s worth a call to Cisco. Stopping during optimization could be a whole bunch of things performance related, check into things like memory, processor, disk utilization first.

245
Views
0
Helpful
1
Replies
CreatePlease to create content