As far as I can tell, HQ makes no provision for scheduling worksheets other than the 401.
I searched the Google archive for this group and found part of a thread containing this little tidbit:
You must insert data into [Worksheet], [WorksheetStore],
> [WorksheetHistory] and WorksheetItem for 250/260, and
> Worksheet_ItemPrice, ItemCost... ItemTax for sales information..
I think I'd like to schedule a daily 250 worksheet and possibly a 350 as well.
Just to be perfectly clear, I'm closer to being an SQL newbie than an SQL expert.
I understand the query part. INSERT INTO Worksheet (Style, EffectiveDate, Status, Notes, Title, FromDate) VALUES (250,Today 6:30PM,2,'Auto 250','Automated Daily Item Update',NOW)
What I don't know how to do: Generate the date fields "Today 6:30PM" and "NOW" Schedule the query.
I've got SQL 2000 (as part of SBS Premium), and I am certain that I have the capability to do this. I just don't have the knowledge.
Thanks, Tom