Automatic Worksheet 250

Oct 10, 2006 6 Replies

Looking for a way to issue a complete worksheet 250 to run in the middle of the night when all stores are closed. Found some threads that people were talking about this but nothing that tells someone how to do it. I am aspiring to be better with SQL scripting but I am still a newbie to SQL. Not sure if maybe there is a batch file that I could create to do this, like I have made to backup the database every night. If someone knows of a way to do this please let me know I would greatly appreciate it. I have 3 stores and am using RMS Ver 1.3R, I doubt that matters just letting everyone know what I am working with.



Thanks in advance.



Neil


I guess no one uses automatic 250 worksheets or everyone knows how to make them and I am in the dark.

nt

"nt8378" wrote:

Can u please explain it further? do u want to automatically create 250? what is your criteria? LastUpdated?

Thank you for your response. I was thinking about doing an entire 250 for all Suppliers. However if the database ever got too large it would be a good idea to have it do just LastUpdated items. I am mainly looking for a bone dry structure to follow and I could tweek it as I went. If you know how to make a worksheet run on a schedule please let me know. Thanks again.

Neil

"Nashat" wrote:

i have a job that creates 250 worksheets based on the LastUpdated field, it could be changed to look any other field, is it what u need? or u r much interested in the worksheet effective time?

Nashat,

Please send me your job that you created on the worksheet 250. It just may be what I am looking for. I would greatly appreciate it. My e-mail is snipped-for-privacy@kidsstuffsuperstore.com Thank you again for your reply.

Sincerely, Neil

"Nashat" wrote:

could I have a copy of the auto 250 worksheet too?

I'm very new to RMS (2-3 weeks), so just learning. How do I "get in" to the system to make changes in SQL (new to SQL too, I have a book, and want to be able to make these changes)

thanks

snipped-for-privacy@connaught-house.co.uk

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required