Hola a todos, al intentar ejecutar un checkdb por la db13 inmediatamente me genera el error que muestro abajo, mi BD es SQL Server 2005 y sap ECC 6.0.
Alguna idea?
Saludos.
exec msdb..sp_add_job @originating_server = '(local)',@job_name = "SAP CCMS Check
Database
D01 [20080804093731-1-093731]",@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 D01
[20080804093731-1-093731]',@step_id = 1,@step_name = 'CCMS-Step1 ',@subsystem =
'TSQL',@command = 'declare @exeStmt nvarchar(2000) exec d01.sap_new_dbcheck
@dbName="D01",@outputfile="$(ESCAPE_NONE(SQLDIR))
\CCMS_CHECK_DB_HIST_2008.txt",@bkupSim =
"Y",@exeStmt = @exeStmt OUTPUT',@database_name = 'D01',@output_file_name =
'$(ESCAPE_NONE(SQLDIR))\CCMS_CHECK_DB_HIST_2008.tx t',@flags = 2
dbcc checkdb( D01 ) with no_infomsgs
exec msdb..sp_add_jobschedule @job_id = null,@job_name = 'SAP CCMS Check Database
D01
[20080804093731-1-093731]',@name = 'CCMS-sche1',@enabled = 1,@freq_type
=1,@freq_interval =
1,@freq_subday_type = 0,@freq_subday_interval = 0,@active_start_date =
20080804,@active_start_time = 93731 ,@freq_recurrence_factor = 0
exec msdb..sp_add_jobserver @job_name = 'SAP CCMS Check Database D01
[20080804093731-1-093731]',@server_name = '(local)'
Alguna idea?
Saludos.
exec msdb..sp_add_job @originating_server = '(local)',@job_name = "SAP CCMS Check
Database
D01 [20080804093731-1-093731]",@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 D01
[20080804093731-1-093731]',@step_id = 1,@step_name = 'CCMS-Step1 ',@subsystem =
'TSQL',@command = 'declare @exeStmt nvarchar(2000) exec d01.sap_new_dbcheck
@dbName="D01",@outputfile="$(ESCAPE_NONE(SQLDIR))
\CCMS_CHECK_DB_HIST_2008.txt",@bkupSim =
"Y",@exeStmt = @exeStmt OUTPUT',@database_name = 'D01',@output_file_name =
'$(ESCAPE_NONE(SQLDIR))\CCMS_CHECK_DB_HIST_2008.tx t',@flags = 2
dbcc checkdb( D01 ) with no_infomsgs
exec msdb..sp_add_jobschedule @job_id = null,@job_name = 'SAP CCMS Check Database
D01
[20080804093731-1-093731]',@name = 'CCMS-sche1',@enabled = 1,@freq_type
=1,@freq_interval =
1,@freq_subday_type = 0,@freq_subday_interval = 0,@active_start_date =
20080804,@active_start_time = 93731 ,@freq_recurrence_factor = 0
exec msdb..sp_add_jobserver @job_name = 'SAP CCMS Check Database D01
[20080804093731-1-093731]',@server_name = '(local)'
Comentario