Scheduling a Task

[dnnssr]

if my task executed first time then the next time it will start only if
first time it completed

i mean i don't want more the one iinstance of the same exe running


is short my exe will run daily in some interval and when one intacne will get finsihed then only another instance will execute

[dnnssr]

I have two exe's

1. First one continously monitor a table and if a new record comes it trigger another exe and pass this new record data to that exe and there i do some operations like web recording etc

but i am confused on the scheduling

if in table may be there are multiple new records then what will happen and how can i handle this any demo samples will help a lot


first exe will run continously and will trigger another exe if it will found a new record.

[forumsupport]

Hello,

The mentioned scenario can be automated with a single super task that you can schedule as per the requirement. You can call second task from the main task depending upon the results from SQL table using Run Task command.

What you can do is,

. Create a Auto number primary Key field say 'UniqueID' to uniquely identify particular record in a table.
. Create a variable say $UniqueIDVar$ that reads value from a text file
. In second task or exe, log this fields value in some text file.
. In first task or exe, search for, unique id greater than the one that is logged. Let’s say the unique id logged in the text file is 3 then the first task would search for records greater than 3.
. You can export the records returned into CSV file using 'Execute SQL' Database command.
. Check for the existence of same CSV file, if exists then call second task, connect to CSV file, fill webform and at the end log the 'UniqueID' value to $UniqueIDVar$ so that the Main task would then later search for new records.
. Delete the CSV file after filling the web form.

We have attached a sample as per the requirement. We have used Access database in this sample so you may need to change the Database commands to connect and get data from SQL database.

You can schedule the MainTask.atmn to start running at pre-defined time. Also, set it to repeat until you hit Esc to monitor the database continuously.

Hope that helps.