Setting Bin Priority

[wwwedward]

We are using mutli-bin soft allocation, sql 2000 7.6.103.5. I need to change the default bin priority to 1 for our pick sequence bins are floor level bins… We create these on the fly and the default is 98. I cannot change the default because this is correct for a portion of bins. So I need to run this little script at night against my bin file. Here is the script which works, but what is the best way to run this automatically at night??

UPDATE IMINVBIN_SQL
SET bin_priority = 1
WHERE (loc = '01') AND (bin_no LIKE '%0')

I think I would need to add some odbc connection information also?? Any Ideas?

 

[PhilPPhillips]

Create a job in the Enterprise server Manager.

In the Enterprise server manager, select the server, click on Management, then SQL server Agent, right click on Jobs and select create new job.

 

[wwwedward]

Thanks I can see the forest.