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
Not when you have to pass the SQL Agent step as a parameter :-) Otherwise, yes it does. -- Programmer-analyst Statistics Canada --
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.
Focus Search - 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 --
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.'
Focus Search - Restart the agent with the ojdbc7.jar 5