Search

1 to 9 of 9
Sort by

Discussion Reply
RE: Executing MS-SQL Agent Job and wait until the job has been finished

Well... not for us! Not when you have to pass the SQL Agent step as a parameter :-) Otherwise, yes it does. -- Programmer-analyst Statistics Canada --


Discussion Reply
RE: Executing MS-SQL Agent Job and wait until the job has been finished

I'm kinda rusty on this stuff, but I seem to remember we execute SQLServer packages with the EXEC instruction directly from our UC4 SQLServer jobs, and they seem to wait for completion. -- Pete --


Discussion Reply
RE: Executing MS-SQL Agent Job and wait until the job has been finished

@SET SERVER=&SERVER# @SET DATABASE=&DATABASE# @SET STEPNAME=&STEPNAME# @ECHO Server=%SERVER% @ECHO Database=%DATABASE% @ECHO StepName=%STEPNAME% @ECHO Job SUFTransferTablesAutomated to run on server %SERVER% ! *** Call stored proc to launch the SQL Agent Job *** @ECHO SQLCMD.EXE -S %SERVER% -d %DATABASE% -Q "EXEC SurveyInterface.uspStartSqlAgentJob @jobname=SUFTransferTablesAutomated, @stepname=%STEPNAME%" -b -s "|" SQLCMD.EXE -S %SERVER% -d %DATABASE% -Q "EXEC SurveyInterface.uspStartSqlAgentJob @jobname=SUFTransferTablesAutomated, @stepname=%STEPNAME%" -b -s "|" !


Discussion Post
Executing MS-SQL Agent Job and wait until the job has been finished

Hey guys! I am trying to start a Sql Agent job at a specific step, and the OA function SQL EXECUTE JOB does not work with step's parameter. I found information in this post ( https://community.broadcom.com/enterprisesoftware/communities/community-home/digestviewer/viewthread?MessageKey=444d7af4...



Discussion Reply
Re: sqlserver "logfile_usage" alert

Hi CA Team, Any update on this issue. Me too getting this error on some sql probe servers. #cauim #casupport #sqldatabase #sqlserverprobe #sqlserver


Discussion Thread 6
sqlserver "logfile_usage" alert

Focus Search - Profile XXXXX, checkpoint logfile_usage, query execution did not run successfully, error msg: Profile: Tup003/logfile_u sage/(ProcessResult) - COM Error: Code=0x80004005 Source=Microsoft OLE DB Provider for ODBC Drivers Description=[Microsoft][ODBC SQL Server Driver][SQL Server]Server user 'nimmon' is not a valid user in database 'model'. Profile: xxxxxxx/logfile_usage/Run Query - DB Provider: Code=0x0x80004005 Source=Microsoft OLE DB Provider for ODBC Drivers Description=[Microsoft][ODBC SQL Server Driver][SQL Server]Server user 'nimmon' is not a valid user in database 'INF_ABERDEEN'


Discussion Reply
Re: SQL Job Error Message: java.lang.UnsatisfiedLinkError: ocijdbc11 (Not found in java.library.path)

Oracle Database version JDBC JAR files specific to the release 12.2 or 12cR2 ojdbc8.jar with JDK 8 12.1 or 12cR1 ojdbc7.jar with JDK 7 and JDK 8 ojdbc6.jar with JDK 6 11.2 or 11gR2 ojdbc6.jar with JDK 6, JDK 7, and JDK 8 (Note: JDK7 and JDK8 are supported in 11.2.0.3 and 11.2.0.4 only) ojdbc5.jar with JDK 5 Source: compatibility table of Oracle and JDBC/JDK versions


Discussion Thread 7
SQL Job Error Message: java.lang.UnsatisfiedLinkError: ocijdbc11 (Not found in java.library.path)

Focus Search - When checking the logfile you see the following : 20161019/132830.244 - U02012035 Start Agent query with RunID '******'. 20161019/132830.246 - U02012041 Query a table without waiting for a database. RunID: '******' 20161019/132830.248 - U02012046 RunID '******': Failed to create a database connection: 'java.lang.UnsatisfiedLinkError: no ocijdbc11 in java.library.path' 20161019/132830.250 - U02012037 Query with RunID '******' ended abnormally