Ho mbartosh,
There is no external 'thing' from Visualcron you can call from a stored procedure to run a specific job.
I'm using the eventlog of SQL server as middleware, a layer between the stored procedure and Visualcron. 😲
The way I explained it is using a eventlog trigger on a job you want to run from your stored procedure. A stored procedure is capable of writing an entry in the eventlog of the server where it is running (sql server).
The evenlog trigger on the specific job is monitoring the eventlog of that machine and if the query matches the event you create with your stored procedure, the job will run.
You can give all of you jobs this eventlog trigger and query on something specific, like the job name in the description. When you setup your stored procedure right with the right job name in the message (using the xp_logevent in your stored procedure) you can run every job from Visualcron.
CREATE PROCEDURE RunVisualcronJobByName
@JobName varchar(100)
AS
BEGIN
USE MASTER
EXEC xp_logevent 60000, 'Visualcron job start: ' + @JobName, informational
END
You than can add the eventlog trigger on your jobs. Setup the right sql server (use good privileges) and:
Event type: Information (AND)
Description contains: JobName (AND) <-- replace with your jobname
Source: MSSQLSERVER (AND)
At this time you are completely lost 🤬 or I have made friends 😍.
I hope I helped you solving your issue.
Regards,
Erik
Uses Visualcron since 2006.