Search

1 to 7 of 7
Sort by

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

The SQL Agent requires that the JDBC driver JAR file be installed in the jdbc subdirectory of the directory containing the SQL Agent JAR file ucxjsqlx.jar


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

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


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

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.



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

WAITFOR DELAY '00:00:30'; END -- Get the Status when job completed SET @JobHistoryID = (SELECT MAX(job history id) FROM msdb.dbo.JobActivity View WHERE job id= @jobID) SELECT @status = run status FROM msdb.dbo.JobHistory View WHERE job id = @jobID AND job history id = @JobHistoryID SELECT @status message = message FROM msdb.dbo.JobHistory View WHERE job id = @jobID AND job history id = @JobHistoryID SET @TimeStamp = GETDATE() PRINT @TimeStamp IF @status = 1 PRINT 'Status output:' + @status message ELSE BEGIN RAISERROR (@status message, 16, 1) END END ELSE BEGIN SET @message = 'The Sql Agent job ' + @JobName + ' does not exists.'