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
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? > >
Chris,
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? > >
Nashat,
I would be very interested in the full script, could you possibly send it to me.
Thank you very much
"Ahmed Nashat" wrote:
@cmdexec_success_code = 0, @flags = 0, @retry_attempts = 0, @retry_interval = 1, @output_file_name = N'', @on_success_step_id = 0, @on_success_action = 1, @on_fail_step_id = 0, @on_fail_action = 2
message news:% snipped-for-privacy@TK2MSFTNGP05.phx.gbl...
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
message news:uJ$ snipped-for-privacy@TK2MSFTNGP05.phx.gbl...
begin 666 job script.sql M__XM`"T`( !3`&,`0!S`&H`;P!B`',`90!R`'8`90!R`',`( `-``H`( `@`" `( `@ M`" `( `@`" `( `@`" `( `@`%
yes i did, but it seems that u r using Internet Explorer, you must use news reader like Outlook Express to download attachements
Ahmed,
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.
Thank you very much, Neil
"Ahmed Nashat" wrote:
Have something to add? Share your thoughts — no account required.
Ask the community — no account required