Skip to Content
author's profile photo Former Member
Former Member

Cant create CCMS Check Database job with DBAcockpit

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?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Jun 29, 2011 at 05:28 PM

    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)

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.