I'm sure this has been mentioned before, but I can't find it anywhere.
People not doing 250 worksheets (and others) is a real problem for me. Is there a SQL command that can be run every day at say 23:00 to perform a 250 to send all data to the shops?
remove the condition if you want the job to send all items
Nashat
"Chris Allsopp - Connaught House" wrote in message news:uJ$ snipped-for-privacy@TK2MSFTNGP05.phx.gbl... > I'm sure this has been mentioned before, but I can't find it anywhere. > > People not doing 250 worksheets (and others) is a real problem for me. Is > there a SQL command that can be run every day at say 23:00 to perform a 250 > to send all data to the shops? > >
find attached the job script, please search in the script for HQSample and replace it with your database name, the job will run each day at 23:00 and it well send ONLY the items updated in the same day, you can remove the condition if you want the job to send all items
Nashat
"Chris Allsopp - Connaught House" wrote in message news:uJ$ snipped-for-privacy@TK2MSFTNGP05.phx.gbl... > I'm sure this has been mentioned before, but I can't find it anywhere. > > People not doing 250 worksheets (and others) is a real problem for me. Is > there a SQL command that can be run every day at say 23:00 to perform a 250 > to send all data to the shops? > >
replace it with your database name, the job will run each day at 23:00 and it well send ONLY the items updated in the same day, you can remove the condition if you want the job to send all items
I would love this script. When I synced my newsreader in Outlook Express it only dates back to June. This Post started in April. If you could repost the script I would be very pleased.
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here.
All logos and trade names are the property of their respective owners.