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

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

New Member

SQL Job error out

hello,

the following message is detected in the eventviewer of the Call Manager

Event Type: Warning

Event Source: SQLSERVERAGENT

Event Category: Job Engine

Event ID: 208

Date: 8/27/2008

Time: 5:00:01 PM

User: N/A

Computer: CALLMANAGER

Description:

SQL Server Scheduled Job 'Monitor Disk Space' (0x05E0927165DF1A4EA2A2EB1C195FCA14) - Status: Failed - Invoked on: 2008-08-27 17:00:00 - Message: The job failed. The Job was invoked by Schedule 19 (Schedule 1). The last step to run was step 2 (TruncateCCMLog).

What does it meaning ?

Thanks at advance.

8 REPLIES

Re: SQL Job error out

Go to Enterprise Managerexpand 'Management' nodeexpand 'sql server agent' nodeclick on 'jobs'Doubleclick on 'Optimization for CIPT' jobClick on 'steps' tabDoubleclick on step 2, the last stepclick on 'Advanced' tabfor 'On success action' field select 'quit the job reporting success'Click 'Apply'Click 'OK'Click 'OK'.

New Member

Re: SQL Job error out

hello,

but the job that has problem of failure is Monitor Disk Space not the optimisation for CIPT.

it's linked to the Optimisation job or what ?

Regards

New Member

Re: SQL Job error out

hello,

when i access to the enterprise Manager>Monitor Disk Space and i see the history job, the following message appeared :

Executed as user: CALLMANAGER\SQLSvc. Cannot insert the value NULL into column 'owner', table 'tempdb.dbo.#spdbdesc___________________________________________________________________________________________________________000100004B46'; column does not allow nulls. INSERT fails. [SQLSTATE 23000] (Error 515) The statement has been terminated. [SQLSTATE 01000] (Error 3621). The step failed.

thanks at advance

Cisco Employee

Re: SQL Job error out

driss

have you gone thru the link i provided to fix that EXACT issue???

HTH

java

if this helps, please rate

HTH

java

if this helps, please rate

www.cisco.com/go/pdi
New Member

Re: SQL Job error out

hello,

thanks for reply.

i have not applied it because it regards the CCM and CDR databases of which the owner changed to unknown.But, for this case the ownser for CCM and CDR database are known (Computer\Administrator)

thanks to confirm if it's coorect or i must follow what's described at the link.

Regards

New Member

Re: SQL Job error out

hello,

i'm also waiting for your answer about the confirmation of procedure.

Regards

Cisco Employee

Re: SQL Job error out

In the Cisco CallManager 4.x, an error message for the "Monitor Disk Space" SQL Server Scheduled Job appears at regular intervals in the application logs with "Event ID: 208"

http://www.ciscotaccc.com/kaidara-advisor/voice/showcase?case=K26333280

HTH

java

if this helps, please rate

HTH

java

if this helps, please rate

www.cisco.com/go/pdi
New Member

Re: SQL Job error out

hello,

Even if i have applied following the link above.nothing happens and the same message is appeared at the appropriate time.

Regards

148
Views
5
Helpful
8
Replies