Hello,
I need to start ibots based on when a job in another system finishes. My best approach, so far, is to have a stored procedure in SQL Server that checks for Job A to be finished in SAP BW and then will update the scheduler tables to kick off the iBots. We currently manually start these ibots daily, 365 days a year. I need this process to be changed.
Currenlty, the scheduler tables are stored in a database in SQL.
I initially set the ibot up through Delivers, so the tables have been updated by the system. I need to figure out how to force the iBot to start. I can update the start date/time in S_NQ_JOB, but the time will come and go and it won't run. It will run when another ibot runs that is set up through the scheduler. I feel like I am missing an update to a table somewhere that will trigger the scheduler to look for job runtimes and to kick it off.
This is what I am updating in S_NQ_JOB:
update S_NQ_JOB
set NEXT_RUNTIME_TS = '2014-06-25 16:06:00.000',
start_hour= 12,
start_Minute = 06,
where JOB_ID = 205
any ideas or blogs/documentation for me to read through would be much appreciated. I have been researching to no avail so far.