Where are Scheduled Tasks located in SIM DB

[Mariano De Luca]

Have a question, using SQL 2005. I have my SIM DB that containts 100+ tasks I created. I had to do a restore of the DB from a previous date and lost all the tasks created after that date. How can I import the scheduled tasks from the SQL db and put it into the current one I am using? What table are they listed in?

[NJK-Work]

In SQL 2000 (what I use), the table is simply called "tasks". There is also a "taskQueryContents" and "taskSchedule" table. I am assuming the three tables are related, but as I don't have access to the schema, I am not sure how.

I would bet SQL2005 and SQL2000 use nearly identical table names if not 100% identical.

Nelson