cancel
Showing results for 
Search instead for 
Did you mean: 

Cant create CCMS Check Database job with DBAcockpit

Former Member
0 Kudos

In Solution Manager Diagnostics in Solution Manager we have registered

a connection to a Business Objects Enterprise xi3 DB

which is running on a SQL Server 2008 Database platform.

The SQL Server instance name is JDGSBOBPRD00\JDGSBOBPRD00

The database name is JDGSBOBPRD00

This was successful and we where able to connect via the Solution

Manger dbacockpit transaction to the Business Objects Enterprise xi3 DB

and run the various other transactions available in dbacockpit.

When we try to add a CCMS Check Database via the Jobs DBA Planning

Calendar it works and the entry is create in the calendar.

If I try run the job by clicking Execute I get this error:

"14262 [Microsoft][SQL Server Native Client10.0][SQL Ser ver]The

specified @job_name ('SAP CCMS Check Datab ase JDGSBOBP [20110621151811-2-151811]') does not"

When I look at the SQL Server Database via SQL Server Management Studio

I don't see any job relating to the CCMS Check Database.

So it the error I get makes sense as the job does not exist.

From the Preview tab when you create a CCMS Check Database job, I see

the following SQL commands that are generated to create the job:

exec msdb..sp_add_job @originating_server = '(local)',@job_name = "SAP

CCMS Check Database

JDGSBOBP [20110621142338-7-030000]",@enabled = 1,@description = "SAP

CCMS JOB",@start_step_id

= 1, @category_name = NULL,@category_id = NULL

exec msdb..sp_add_jobstep @job_id = null,@job_name = 'SAP CCMS Check

Database JDGSBOBP

[20110621142338-7-030000]',@step_id = 1,@step_name = 'CCMS-

Step1 ',@subsystem = 'TSQL',

@command = 'declare @exeStmt nvarchar(2000) exec

SAPSolMan710.sap_new_dbcheck

@dbName="JDGSBOBP",@outputfile="$(ESCAPE_NONE(SQLDIR))

\CCMS_CHECK_DB_HIST_2011.txt",

@bkupSim = "Y",@exeStmt = @exeStmt OUTPUT',@database_name

= 'JDGSBOBP',@output_file_name =

'$(ESCAPE_NONE(SQLDIR))\CCMS_CHECK_DB_HIST_2011.txt',@flags = 2

dbcc checkdb( JDGSBOBP ) with no_infomsgs

exec msdb..sp_add_jobschedule @job_id = null,@job_name = 'SAP CCMS

Check Database JDGSBOBP

[20110621142338-7-030000]',@name = 'CCMS-sche1',@enabled = 1,@freq_type

=8,@freq_interval = 1,

@freq_subday_type = 1,@freq_subday_interval = 0,@active_start_date =

20110626,

@active_start_time = 30000 ,@freq_recurrence_factor = 1

exec msdb..sp_add_jobserver @job_name = 'SAP CCMS Check Database

JDGSBOBP

[20110621142338-7-030000]',@server_name = '(local)'

I noticed that the DB Name is "JDGSBOBP" and the the actual name

is "JDGSBOBPRD00" so it looks like only the first 8 characters are used.I did find SAP Note 1413688 but dont think this applies to my situation.Is there any work around concerning this problem?

Accepted Solutions (0)

Answers (1)

Answers (1)

leslie_moser
Explorer
0 Kudos

Hello Gareth,

I work in the development team for SQL Server porting on NetWeaver products and I work a lot with the Solution Manager integration.

Can you please open a customer message for this problem in component BC-DB-MSS? This sounds like a new problem to me.

Thank you,

Leslie Moser

Microsoft SQL Server Support

SAP Database Development - Microsoft Platforms (Redmond, WA)

Former Member
0 Kudos

Thanks Leslie, I have logged a message. Got this reply

Dear Customer,

I am the responsible developer for this transaction(Planning

calendar). and I connected to teh system and checked the problem..

Thanks for the detailed description of the problem..

I also debugged the Planning calendarreports and was able to create

the Dbcc checkdb job in your SQL Agent.. Please delete the job in

your SQL Server as I don't have remote access at OS level.

I will check with my colleague about this and update the message later.

Thanks and Best Regards

Former Member
0 Kudos

A SAP Note 1609988 was created for this issue.

My problem has been solved.

Regards,

Edited by: Gareth Bosman on Jul 15, 2011 2:35 PM