View Single Post
Old 09-27-2007, 07:50 AM   #18
Nikon2ks
New Member
 
Join Date: Sep 2007
Model: 8300
PIN: N/A
Carrier: Cingular
Posts: 1
Default

I'm am getting a different error...can anyone help?? my logs are below....



[30000] (09/27 07:54:44.014):{0x1D24} SQL being executed:
/************************************************** **************************
SchedulePurgeJobs.sql

This SQL script will create the jobs that will remove old data

Procedure List:

(C) 1997-2004 Research In Motion Limited.
************************************************** **************************/

/*

Note - There is no easy of determining if these jobs exists unless one is a member of
sysadm (as queries would be needed against msdb tables and public doesn't have access).

Thus, the installer program running this script will suppress errors that get reported
when the job already exists.

*/

USE msdb
[30000] (09/27 07:54:44.014):{0x1D24} SQL Informational Message from CBESDBInstaller::ExecuteSql.executeDirect: Changed database context to 'msdb'.
[30000] (09/27 07:54:44.014):{0x1D24} SQL executed successfully
[30000] (09/27 07:54:44.014):{0x1D24} SQL being executed:
/*+---------------------------------------------------------------------------
* RIMPurgeHistory - delete rows from ServerConfigHistory table
*+--------------------------------------------------------------------------*/
exec sp_add_job 'RIMPurgeHistoryBESMgmt',
@description = 'Remove old data from history table'
[20000] (09/27 07:54:44.014):{0x1D24} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42000 Native error: 0 Message: Cannot load the DLL xpstar.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.).
[30000] (09/27 07:54:44.014):{0x1D24} SQL Informational Message from CBESDBInstaller::ExecuteSql.executeDirect: The specified @name ('RIMPurgeHistoryBESMgmt') already exists.
[30000] (09/27 07:54:44.014):{0x1D24} SQL executed successfully
[30000] (09/27 07:54:44.014):{0x1D24} SQL being executed:
exec sp_add_jobstep @job_name = 'RIMPurgeHistoryBESMgmt',
@step_id = 1,
@step_name = 'DoIt',
@database_name = 'BESMgmt',
@command = 'exec RemoveOldHistoryRows 60' -- 60 day retention
[20000] (09/27 07:54:44.014):{0x1D24} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42000 Native error: 0 Message: Cannot load the DLL xpstar.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.).
[30000] (09/27 07:54:44.014):{0x1D24} SQL Informational Message from CBESDBInstaller::ExecuteSql.executeDirect: The specified @step_name ('DoIt') already exists.
[30000] (09/27 07:54:44.014):{0x1D24} SQL executed successfully
[30000] (09/27 07:54:44.014):{0x1D24} SQL being executed:
exec sp_add_jobschedule @job_name = 'RIMPurgeHistoryBESMgmt',
@name = 'RIMPurgeHistory',
@freq_type = 8, -- weekly
@freq_interval = 1, -- Sunday
@freq_recurrence_factor = 1, -- every week
@active_start_time = 10000 -- 1:00 am
[20000] (09/27 07:54:44.014):{0x1D24} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42000 Native error: 0 Message: Cannot load the DLL xpstar.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.).
[30000] (09/27 07:54:44.014):{0x1D24} SQL Informational Message from CBESDBInstaller::ExecuteSql.executeDirect: The specified @name ('RIMPurgeHistory') already exists.
[30000] (09/27 07:54:44.014):{0x1D24} SQL executed successfully
[30000] (09/27 07:54:44.014):{0x1D24} SQL being executed:
exec sp_add_jobserver @job_name = 'RIMPurgeHistoryBESMgmt'
[20000] (09/27 07:54:44.014):{0x1D24} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42000 Native error: 0 Message: Cannot load the DLL xpstar.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.).
[30000] (09/27 07:54:44.014):{0x1D24} SQL Informational Message from CBESDBInstaller::ExecuteSql.executeDirect: Job 'RIMPurgeHistoryBESMgmt' is already targeted at server 'EXPCAP-BES'.
[30000] (09/27 07:54:44.014):{0x1D24} SQL executed successfully
[30000] (09/27 07:54:44.014):{0x1D24} SQL being executed:

/*+---------------------------------------------------------------------------
* RIMPurgeDeletedUsers - delete rows from DeletedUserConfig
* no longer used
*+--------------------------------------------------------------------------*/
exec sp_delete_job @job_name = 'RIMPurgeDeletedUsersBESMgmt'
[30000] (09/27 07:54:44.014):{0x1D24} SQL Informational Message from CBESDBInstaller::ExecuteSql.executeDirect: The specified @job_name ('RIMPurgeDeletedUsersBESMgmt') does not exist.
[30000] (09/27 07:54:44.014):{0x1D24} SQL executed successfully
[30000] (09/27 07:54:44.014):{0x1D24} SQL being executed:

/*+---------------------------------------------------------------------------
* RIMPurgeWorkQueue - delete rows from WorkQueue
*+--------------------------------------------------------------------------*/
exec sp_add_job 'RIMPurgeWorkQueueBESMgmt',
@description = 'Remove old work queue entries'
[20000] (09/27 07:54:44.030):{0x1D24} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42000 Native error: 0 Message: Cannot load the DLL xpstar.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.).
[30000] (09/27 07:54:44.030):{0x1D24} SQL Informational Message from CBESDBInstaller::ExecuteSql.executeDirect: The specified @name ('RIMPurgeWorkQueueBESMgmt') already exists.
[30000] (09/27 07:54:44.030):{0x1D24} SQL executed successfully
[30000] (09/27 07:54:44.030):{0x1D24} SQL being executed:
exec sp_add_jobstep @job_name = 'RIMPurgeWorkQueueBESMgmt',
@step_id = 1,
@step_name = 'DoIt',
@database_name = 'BESMgmt',
@command = 'exec RemoveOldWorkQueue 15' -- 15 day retention
[20000] (09/27 07:54:44.030):{0x1D24} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42000 Native error: 0 Message: Cannot load the DLL xpstar.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.).
[30000] (09/27 07:54:44.030):{0x1D24} SQL Informational Message from CBESDBInstaller::ExecuteSql.executeDirect: The specified @step_name ('DoIt') already exists.
[30000] (09/27 07:54:44.030):{0x1D24} SQL executed successfully
[30000] (09/27 07:54:44.030):{0x1D24} SQL being executed:

exec sp_add_jobschedule @job_name = 'RIMPurgeWorkQueueBESMgmt',
@name = 'RIMPurgeWorkQueue',
@freq_type = 8, -- weekly
@freq_interval = 1, -- Sunday
@freq_recurrence_factor = 1, -- every week
@active_start_time = 20000 -- 2:00 am
[20000] (09/27 07:54:44.030):{0x1D24} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42000 Native error: 0 Message: Cannot load the DLL xpstar.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.).
[30000] (09/27 07:54:44.030):{0x1D24} SQL Informational Message from CBESDBInstaller::ExecuteSql.executeDirect: The specified @name ('RIMPurgeWorkQueue') already exists.
[30000] (09/27 07:54:44.030):{0x1D24} SQL executed successfully
[30000] (09/27 07:54:44.030):{0x1D24} SQL being executed:
exec sp_add_jobserver @job_name = 'RIMPurgeWorkQueueBESMgmt'
[20000] (09/27 07:54:44.030):{0x1D24} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42000 Native error: 0 Message: Cannot load the DLL xpstar.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.).
[30000] (09/27 07:54:44.030):{0x1D24} SQL Informational Message from CBESDBInstaller::ExecuteSql.executeDirect: Job 'RIMPurgeWorkQueueBESMgmt' is already targeted at server 'EXPCAP-BES'.
[30000] (09/27 07:54:44.030):{0x1D24} SQL executed successfully
[30000] (09/27 07:54:44.030):{0x1D24} SQL being executed:

/*+---------------------------------------------------------------------------
* RIMCheckFor2GB - warn if we're on MSDE and are approaching MSDE 2GB limit
*+--------------------------------------------------------------------------*/

declare @edition varchar(128)
set @edition = cast(serverproperty('Edition') as varchar(128))
if @edition = 'Desktop Engine'
begin
exec sp_add_job 'RIMCheckFor2GBBESMgmt',
@description = 'Check to see if approaching MSDE 2 GB limit'
end
[20000] (09/27 07:54:44.030):{0x1D24} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42000 Native error: 0 Message: Cannot load the DLL xpstar.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.).
[30000] (09/27 07:54:44.030):{0x1D24} SQL Informational Message from CBESDBInstaller::ExecuteSql.executeDirect: The specified @name ('RIMCheckFor2GBBESMgmt') already exists.
[30000] (09/27 07:54:44.030):{0x1D24} SQL executed successfully
[30000] (09/27 07:54:44.030):{0x1D24} SQL being executed:

declare @edition varchar(128)
set @edition = cast(serverproperty('Edition') as varchar(128))
if @edition = 'Desktop Engine'
begin
exec sp_add_jobstep @job_name = 'RIMCheckFor2GBBESMgmt',
@step_id = 1,
@step_name = 'DoIt',
@database_name = 'BESMgmt',
@command = 'exec CheckFor2GB 1500' -- 1500MB threshold
end
[20000] (09/27 07:54:44.030):{0x1D24} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42000 Native error: 0 Message: Cannot load the DLL xpstar.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.).
[30000] (09/27 07:54:44.030):{0x1D24} SQL Informational Message from CBESDBInstaller::ExecuteSql.executeDirect: The specified @step_name ('DoIt') already exists.
[30000] (09/27 07:54:44.030):{0x1D24} SQL executed successfully
[30000] (09/27 07:54:44.030):{0x1D24} SQL being executed:

declare @edition varchar(128)
set @edition = cast(serverproperty('Edition') as varchar(128))
if @edition = 'Desktop Engine'
begin
exec sp_add_jobschedule @job_name = 'RIMCheckFor2GBBESMgmt',
@name = 'RIMCheckFor2GB',
@freq_type = 8, -- weekly
@freq_interval = 1, -- Sunday
@freq_recurrence_factor = 1, -- every week
@active_start_time = 50000 -- 5:00 am
end
[20000] (09/27 07:54:44.030):{0x1D24} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42000 Native error: 0 Message: Cannot load the DLL xpstar.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.).
[30000] (09/27 07:54:44.030):{0x1D24} SQL Informational Message from CBESDBInstaller::ExecuteSql.executeDirect: The specified @name ('RIMCheckFor2GB') already exists.
[30000] (09/27 07:54:44.030):{0x1D24} SQL executed successfully
[30000] (09/27 07:54:44.030):{0x1D24} SQL being executed:
declare @edition varchar(128)
set @edition = cast(serverproperty('Edition') as varchar(128))
if @edition = 'Desktop Engine'
begin
exec sp_add_jobserver @job_name = 'RIMCheckFor2GBBESMgmt'
end
[20000] (09/27 07:54:44.045):{0x1D24} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42000 Native error: 0 Message: Cannot load the DLL xpstar.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.).
[30000] (09/27 07:54:44.045):{0x1D24} SQL Informational Message from CBESDBInstaller::ExecuteSql.executeDirect: Job 'RIMCheckFor2GBBESMgmt' is already targeted at server 'EXPCAP-BES'.
[30000] (09/27 07:54:44.045):{0x1D24} SQL executed successfully
[30000] (09/27 07:54:44.045):{0x1D24} SQL being executed:

/*+---------------------------------------------------------------------------
* RIMIndexDefrag - defrag the indexes
*+--------------------------------------------------------------------------*/

declare @edition varchar(128)
set @edition = cast(serverproperty('Edition') as varchar(128))
if @edition = 'Desktop Engine'
begin
exec sp_add_job 'RIMIndexDefragBESMgmt',
@description = 'Index defrag'
end
[20000] (09/27 07:54:44.045):{0x1D24} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42000 Native error: 0 Message: Cannot load the DLL xpstar.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.).
[30000] (09/27 07:54:44.045):{0x1D24} SQL Informational Message from CBESDBInstaller::ExecuteSql.executeDirect: The specified @name ('RIMIndexDefragBESMgmt') already exists.
[30000] (09/27 07:54:44.045):{0x1D24} SQL executed successfully
[30000] (09/27 07:54:44.045):{0x1D24} SQL being executed:

declare @edition varchar(128)
set @edition = cast(serverproperty('Edition') as varchar(128))
if @edition = 'Desktop Engine'
begin
exec sp_add_jobstep @job_name = 'RIMIndexDefragBESMgmt',
@step_id = 1,
@step_name = 'DoIt',
@database_name = 'BESMgmt',
@command = 'exec IndexDefrag 10' -- % threshold to defrag
end
[20000] (09/27 07:54:44.045):{0x1D24} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42000 Native error: 0 Message: Cannot load the DLL xpstar.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.).
[30000] (09/27 07:54:44.045):{0x1D24} SQL Informational Message from CBESDBInstaller::ExecuteSql.executeDirect: The specified @step_name ('DoIt') already exists.
[30000] (09/27 07:54:44.045):{0x1D24} SQL executed successfully
[30000] (09/27 07:54:44.045):{0x1D24} SQL being executed:

declare @edition varchar(128)
set @edition = cast(serverproperty('Edition') as varchar(128))
if @edition = 'Desktop Engine'
begin
exec sp_add_jobschedule @job_name = 'RIMIndexDefragBESMgmt',
@name = 'RIMIndexDefrag',
@freq_type = 8, -- weekly
@freq_interval = 1, -- Sunday
@freq_recurrence_factor = 1, -- every week
@active_start_time = 30000 -- 3:00 am
end
[20000] (09/27 07:54:44.045):{0x1D24} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42000 Native error: 0 Message: Cannot load the DLL xpstar.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.).
[30000] (09/27 07:54:44.045):{0x1D24} SQL Informational Message from CBESDBInstaller::ExecuteSql.executeDirect: The specified @name ('RIMIndexDefrag') already exists.
[30000] (09/27 07:54:44.045):{0x1D24} SQL executed successfully
[30000] (09/27 07:54:44.045):{0x1D24} SQL being executed:
declare @edition varchar(128)
set @edition = cast(serverproperty('Edition') as varchar(128))
if @edition = 'Desktop Engine'
begin
exec sp_add_jobserver @job_name = 'RIMIndexDefragBESMgmt'
end
[20000] (09/27 07:54:44.045):{0x1D24} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42000 Native error: 0 Message: Cannot load the DLL xpstar.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.).
[30000] (09/27 07:54:44.045):{0x1D24} SQL Informational Message from CBESDBInstaller::ExecuteSql.executeDirect: Job 'RIMIndexDefragBESMgmt' is already targeted at server 'EXPCAP-BES'.
[30000] (09/27 07:54:44.045):{0x1D24} SQL executed successfully
[30000] (09/27 07:54:44.045):{0x1D24} SQL being executed:

/*+---------------------------------------------------------------------------
* RIMShrinkDb - reduce space used
*+--------------------------------------------------------------------------*/

declare @edition varchar(128)
set @edition = cast(serverproperty('Edition') as varchar(128))
if @edition = 'Desktop Engine'
begin
exec sp_add_job 'RIMShrinkDbBESMgmt',
@description = 'DBCC ShrinkDb'
end
[20000] (09/27 07:54:44.045):{0x1D24} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42000 Native error: 0 Message: Cannot load the DLL xpstar.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.).
[30000] (09/27 07:54:44.045):{0x1D24} SQL Informational Message from CBESDBInstaller::ExecuteSql.executeDirect: The specified @name ('RIMShrinkDbBESMgmt') already exists.
[30000] (09/27 07:54:44.045):{0x1D24} SQL executed successfully
[30000] (09/27 07:54:44.045):{0x1D24} SQL being executed:

declare @edition varchar(128)
set @edition = cast(serverproperty('Edition') as varchar(128))
if @edition = 'Desktop Engine'
begin
exec sp_add_jobstep @job_name = 'RIMShrinkDbBESMgmt',
@step_id = 1,
@step_name = 'Shrink',
@database_name = 'BESMgmt',
@command = 'DBCC SHRINKDATABASE (BESMgmt, 10, NOTRUNCATE)'
end
[20000] (09/27 07:54:44.045):{0x1D24} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42000 Native error: 0 Message: Cannot load the DLL xpstar.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.).
[30000] (09/27 07:54:44.045):{0x1D24} SQL Informational Message from CBESDBInstaller::ExecuteSql.executeDirect: The specified @step_name ('Shrink') already exists.
[30000] (09/27 07:54:44.045):{0x1D24} SQL executed successfully
[30000] (09/27 07:54:44.045):{0x1D24} SQL being executed:

declare @edition varchar(128)
set @edition = cast(serverproperty('Edition') as varchar(128))
if @edition = 'Desktop Engine'
begin
exec sp_add_jobstep @job_name = 'RIMShrinkDbBESMgmt',
@step_id = 2,
@step_name = 'UpdateSize',
@database_name = 'BESMgmt',
@command = 'dbcc updateusage (BESMgmt)'
end
[20000] (09/27 07:54:44.061):{0x1D24} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42000 Native error: 0 Message: Cannot load the DLL xpstar.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.).
[30000] (09/27 07:54:44.061):{0x1D24} SQL Informational Message from CBESDBInstaller::ExecuteSql.executeDirect: The specified @step_name ('UpdateSize') already exists.
[30000] (09/27 07:54:44.061):{0x1D24} SQL executed successfully
[30000] (09/27 07:54:44.061):{0x1D24} SQL being executed:

declare @edition varchar(128)
set @edition = cast(serverproperty('Edition') as varchar(128))
if @edition = 'Desktop Engine'
begin
exec sp_add_jobschedule @job_name = 'RIMShrinkDbBESMgmt',
@name = 'RIMShrinkDb',
@freq_type = 8, -- weekly
@freq_interval = 1, -- Sunday
@freq_recurrence_factor = 1, -- every week
@active_start_time = 40000 -- 4:00 am
end
[20000] (09/27 07:54:44.061):{0x1D24} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42000 Native error: 0 Message: Cannot load the DLL xpstar.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.).
[30000] (09/27 07:54:44.061):{0x1D24} SQL Informational Message from CBESDBInstaller::ExecuteSql.executeDirect: The specified @name ('RIMShrinkDb') already exists.
[30000] (09/27 07:54:44.061):{0x1D24} SQL executed successfully
[30000] (09/27 07:54:44.061):{0x1D24} SQL being executed:
declare @edition varchar(128)
set @edition = cast(serverproperty('Edition') as varchar(128))
if @edition = 'Desktop Engine'
begin
exec sp_add_jobserver @job_name = 'RIMShrinkDbBESMgmt'
end
[20000] (09/27 07:54:44.061):{0x1D24} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42000 Native error: 0 Message: Cannot load the DLL xpstar.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.).
[30000] (09/27 07:54:44.061):{0x1D24} SQL Informational Message from CBESDBInstaller::ExecuteSql.executeDirect: Job 'RIMShrinkDbBESMgmt' is already targeted at server 'EXPCAP-BES'.
[30000] (09/27 07:54:44.061):{0x1D24} SQL executed successfully
[30000] (09/27 07:54:44.061):{0x1D24} SQL being executed:

/*+---------------------------------------------------------------------------
* RIMPurgeMDSMsg - delete rows from MDSPushMessages
*+--------------------------------------------------------------------------*/
exec sp_add_job 'RIMPurgeMDSMsgBESMgmt',
@description = 'Remove old data from push messages table'
[20000] (09/27 07:54:44.061):{0x1D24} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42000 Native error: 0 Message: Cannot load the DLL xpstar.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.).
[30000] (09/27 07:54:44.061):{0x1D24} SQL Informational Message from CBESDBInstaller::ExecuteSql.executeDirect: The specified @name ('RIMPurgeMDSMsgBESMgmt') already exists.
[30000] (09/27 07:54:44.061):{0x1D24} SQL executed successfully
[30000] (09/27 07:54:44.061):{0x1D24} SQL being executed:
exec sp_add_jobstep @job_name = 'RIMPurgeMDSMsgBESMgmt',
@step_id = 1,
@step_name = 'DoIt',
@database_name = 'BESMgmt',
@command = 'exec RemoveMDSPushMsgs'
[20000] (09/27 07:54:44.061):{0x1D24} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42000 Native error: 0 Message: Cannot load the DLL xpstar.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.).
[30000] (09/27 07:54:44.061):{0x1D24} SQL Informational Message from CBESDBInstaller::ExecuteSql.executeDirect: The specified @step_name ('DoIt') already exists.
[30000] (09/27 07:54:44.061):{0x1D24} SQL executed successfully
[30000] (09/27 07:54:44.061):{0x1D24} SQL being executed:
exec sp_add_jobschedule @job_name = 'RIMPurgeMDSMsgBESMgmt',
@name = 'RIMPurgeMDSMsg',
@freq_type = 4, -- daily
@freq_interval = 1, -- every day
@active_start_time = 33300 -- 3:33 am
[20000] (09/27 07:54:44.061):{0x1D24} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42000 Native error: 0 Message: Cannot load the DLL xpstar.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.).
[30000] (09/27 07:54:44.061):{0x1D24} SQL Informational Message from CBESDBInstaller::ExecuteSql.executeDirect: The specified @name ('RIMPurgeMDSMsg') already exists.
[30000] (09/27 07:54:44.061):{0x1D24} SQL executed successfully
[30000] (09/27 07:54:44.061):{0x1D24} SQL being executed:
exec sp_add_jobserver @job_name = 'RIMPurgeMDSMsgBESMgmt'
[20000] (09/27 07:54:44.061):{0x1D24} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42000 Native error: 0 Message: Cannot load the DLL xpstar.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.).
[30000] (09/27 07:54:44.061):{0x1D24} SQL Informational Message from CBESDBInstaller::ExecuteSql.executeDirect: Job 'RIMPurgeMDSMsgBESMgmt' is already targeted at server 'EXPCAP-BES'.
[30000] (09/27 07:54:44.061):{0x1D24} SQL executed successfully
[30000] (09/27 07:54:44.061):{0x1D24} SQL being executed:

/*+---------------------------------------------------------------------------
* RIMPurgeMDSStats - delete rows from MDSPushMessages
*+--------------------------------------------------------------------------*/
exec sp_add_job 'RIMPurgeMDSStatsBESMgmt',
@description = 'Remove old data from stats table'
[20000] (09/27 07:54:44.061):{0x1D24} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42000 Native error: 0 Message: Cannot load the DLL xpstar.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.).
[30000] (09/27 07:54:44.061):{0x1D24} SQL Informational Message from CBESDBInstaller::ExecuteSql.executeDirect: The specified @name ('RIMPurgeMDSStatsBESMgmt') already exists.
[30000] (09/27 07:54:44.061):{0x1D24} SQL executed successfully
[30000] (09/27 07:54:44.061):{0x1D24} SQL being executed:
exec sp_add_jobstep @job_name = 'RIMPurgeMDSStatsBESMgmt',
@step_id = 1,
@step_name = 'DoIt',
@database_name = 'BESMgmt',
@command = 'exec RemoveOldMDSStats'
[20000] (09/27 07:54:44.076):{0x1D24} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42000 Native error: 0 Message: Cannot load the DLL xpstar.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.).
[30000] (09/27 07:54:44.076):{0x1D24} SQL Informational Message from CBESDBInstaller::ExecuteSql.executeDirect: The specified @step_name ('DoIt') already exists.
[30000] (09/27 07:54:44.076):{0x1D24} SQL executed successfully
[30000] (09/27 07:54:44.076):{0x1D24} SQL being executed:
exec sp_add_jobschedule @job_name = 'RIMPurgeMDSStatsBESMgmt',
@name = 'RIMPurgeMDSStats',
@freq_type = 4, -- daily
@freq_interval = 1, -- every day
@active_start_time = 22200 -- 2:22 am
[20000] (09/27 07:54:44.076):{0x1D24} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42000 Native error: 0 Message: Cannot load the DLL xpstar.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.).
[30000] (09/27 07:54:44.076):{0x1D24} SQL Informational Message from CBESDBInstaller::ExecuteSql.executeDirect: The specified @name ('RIMPurgeMDSStats') already exists.
[30000] (09/27 07:54:44.076):{0x1D24} SQL executed successfully
[30000] (09/27 07:54:44.076):{0x1D24} SQL being executed:
exec sp_add_jobserver @job_name = 'RIMPurgeMDSStatsBESMgmt'
[20000] (09/27 07:54:44.076):{0x1D24} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42000 Native error: 0 Message: Cannot load the DLL xpstar.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.).
[30000] (09/27 07:54:44.076):{0x1D24} SQL Informational Message from CBESDBInstaller::ExecuteSql.executeDirect: Job 'RIMPurgeMDSStatsBESMgmt' is already targeted at server 'EXPCAP-BES'.
[30000] (09/27 07:54:44.076):{0x1D24} SQL executed successfully
[30000] (09/27 07:54:44.076):{0x1D24} SQL being executed:



/*+---------------------------------------------------------------------------
* RIMPurgeOTASL - delete rows from DSUPRequest
*+--------------------------------------------------------------------------*/
use msdb
[30000] (09/27 07:54:44.076):{0x1D24} SQL Informational Message from CBESDBInstaller::ExecuteSql.executeDirect: Changed database context to 'msdb'.
[30000] (09/27 07:54:44.076):{0x1D24} SQL executed successfully
[30000] (09/27 07:54:44.076):{0x1D24} SQL being executed:
exec sp_add_job 'RIMPurgeOTASLBESMgmt',
@description = 'Remove old data from stats table'
[20000] (09/27 07:54:44.076):{0x1D24} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42000 Native error: 0 Message: Cannot load the DLL xpstar.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.).
[30000] (09/27 07:54:44.076):{0x1D24} SQL Informational Message from CBESDBInstaller::ExecuteSql.executeDirect: The specified @name ('RIMPurgeOTASLBESMgmt') already exists.
[30000] (09/27 07:54:44.076):{0x1D24} SQL executed successfully
[30000] (09/27 07:54:44.076):{0x1D24} SQL being executed:
exec sp_add_jobstep @job_name = 'RIMPurgeOTASLBESMgmt',
@step_id = 1,
@step_name = 'DoIt',
@database_name = 'BESMgmt',
@command = 'exec RemoveOldOTASL 31'
[20000] (09/27 07:54:44.076):{0x1D24} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42000 Native error: 0 Message: Cannot load the DLL xpstar.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.).
[30000] (09/27 07:54:44.076):{0x1D24} SQL Informational Message from CBESDBInstaller::ExecuteSql.executeDirect: The specified @step_name ('DoIt') already exists.
[30000] (09/27 07:54:44.076):{0x1D24} SQL executed successfully
[30000] (09/27 07:54:44.076):{0x1D24} SQL being executed:
exec sp_add_jobschedule @job_name = 'RIMPurgeOTASLBESMgmt',
@name = 'RIMPurgeOTASL',
@freq_type = 8, -- weekly
@freq_interval = 1, -- Sunday
@freq_recurrence_factor = 1, -- every week
@active_start_time = 14400 -- 1:44 am
[20000] (09/27 07:54:44.076):{0x1D24} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42000 Native error: 0 Message: Cannot load the DLL xpstar.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.).
[30000] (09/27 07:54:44.076):{0x1D24} SQL Informational Message from CBESDBInstaller::ExecuteSql.executeDirect: The specified @name ('RIMPurgeOTASL') already exists.
[30000] (09/27 07:54:44.076):{0x1D24} SQL executed successfully
[30000] (09/27 07:54:44.076):{0x1D24} SQL being executed:
exec sp_add_jobserver @job_name = 'RIMPurgeOTASLBESMgmt'
[20000] (09/27 07:54:44.264):{0x1D24} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42000 Native error: 0 Message: Cannot load the DLL xpstar.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.).
[20000] (09/27 07:54:44.264):{0x1D24} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42000 Native error: 0 Message: Cannot load the DLL xpstar.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.).
Offline   Reply With Quote