Re: Automatic Worksheet 250

I'm so sorry Neil for the big delay. find attached the job script, it's implemented based on the following:- 1.. DB name is RMSHQ 2.. job schedule is 23:00 on a daily basis
3.. the job create a 250 WS for the items updated in the same day 4.. the worksheet will be created for all the stores u have 5.. the worksheet effective time will be the same as the job execution time (23:00) Please let me know if u have any questions Nashat
face=Arial size=2>...<BR>&gt;&gt; &gt;&gt; &gt;I guess no one uses automatic 250 worksheets or everyone knows how to <BR>&gt;&gt; &gt;&gt; &gt;make<BR>&gt;&gt; &gt;&gt; &gt; them and I am in the dark.<BR>&gt;&gt; &gt;&gt; &gt;<BR>&gt;&gt; &gt;&gt; &gt; nt<BR>&gt;&gt; &gt;&gt; &gt;<BR>&gt;&gt; &gt;&gt; &gt; "nt8378" wrote:<BR>&gt;&gt; &gt;&gt; &gt;<BR>&gt;&gt; &gt;&gt; &gt;&gt; Looking for a way to issue a complete worksheet 250 to run in the <BR>&gt;&gt; &gt;&gt; &gt;&gt; middle<BR>&gt;&gt; &gt;&gt; &gt;&gt; of<BR>&gt;&gt; &gt;&gt; &gt;&gt; the night when all stores are closed. Found some threads that people <BR>&gt;&gt; &gt;&gt; &gt;&gt; were<BR>&gt;&gt; &gt;&gt; &gt;&gt; talking about this but nothing that tells someone how to do it. I am<BR>&gt;&gt; &gt;&gt; &gt;&gt; aspiring<BR>&gt;&gt; &gt;&gt; &gt;&gt; to be better with SQL scripting but I am still a newbie to SQL. Not <BR>&gt;&gt; &gt;&gt; &gt;&gt; sure<BR>&gt;&gt; &gt;&gt; &gt;&gt; if<BR>&gt;&gt; &gt;&gt; &gt;&gt; maybe there is a batch file that I could create to do this, like I <BR>&gt;&gt; &gt;&gt; &gt;&gt; have<BR>&gt;&gt; &gt;&gt; &gt;&gt; made<BR>&gt;&gt; &gt;&gt; &gt;&gt; to backup the database every night. If someone knows of a way to do <BR>&gt;&gt; &gt;&gt; &gt;&gt; this<BR>&gt;&gt; &gt;&gt; &gt;&gt; please let me know I would greatly appreciate it. I have 3 stores and <BR>&gt;&gt; &gt;&gt; &gt;&gt; am<BR>&gt;&gt; &gt;&gt; &gt;&gt; using RMS Ver 1.3R, I doubt that matters just letting everyone know <BR>&gt;&gt; &gt;&gt; &gt;&gt; what<BR>&gt;&gt; &gt;&gt; &gt;&gt; I am<BR>&gt;&gt; &gt;&gt; &gt;&gt; working with.<BR>&gt;&gt; &gt;&gt; &gt;&gt;<BR>&gt;&gt; &gt;&gt; &gt;&gt; Thanks in advance.<BR>&gt;&gt; &gt;&gt; &gt;&gt;<BR>&gt;&gt; &gt;&gt; &gt;&gt; Neil<BR>&gt;&gt; &gt;&gt;<BR>&gt;&gt; &gt;&gt;<BR>&gt;&gt; &gt;&gt; <BR>&gt;&gt; <BR>&gt;&gt; <BR>&gt;&gt;</FONT> </BLOCKQUOTE></BODY></HTML>
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
Nashat,
I am new to RMS and would like to automate worksheet 250 as well, would you be able to send it to me.
snipped-for-privacy@tooltown.ca
Thanks
"Nashat" wrote:

Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
It's already attached in my post

Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload

BeanSmart.com is a site by and for consumers of financial services and advice. We are not affiliated with any of the banks, financial services or software manufacturers discussed here. All logos and trade names are the property of their respective owners.

Tax and financial advice you come across on this site is freely given by your peers and professionals on their own time and out of the kindness of their hearts. We can guarantee neither accuracy of such advice nor its applicability for your situation. Simply put, you are fully responsible for the results of using information from this site in real life situations.