SQL Auto 250 worksheet

Posted by Ahmed Nashat on May 10, 2007, 11:21 am

Please log in for more thread options

> Nashat,

> I would be very interested in the full script, could you possibly send it

> to

> me.

> Thank you very much

> "Ahmed Nashat" wrote:

>> locate this line

>> where Item.[LastUpdated] > getdate()-''23:00:00''', @database_name =

>> N'HQSample', @server = N'', @database_user_name = N'', @subsystem =

>> N'TSQL', @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

>> Thanks Nashat,

>> I've looked at the script though and I can't find HQSample in it

>> Chris

>> 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

>> > 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?

>> >

begin 666 job script.sql
M__XM`"T`( !3`&,`<@!I`' `= `@`&<`90!N`&4`<@!A`'0`90!D`" `;P!N
M`" `,0`X`"`, `T`"`,@`P`# `-P`@`# `.0`Z`#(`. `@`#4&#0`*`"T`
M+0`@`$(`>0`Z`" `<P!A``T`"@`M`"T`( !3`&4`<@!V`&4`<@`Z`" `* !,
M`$`0P!!`$P`*0`-``H`#0`*`$(`10!'`$D`3@`@`%0`4@!!`$X`4P!!`$,`
M5 !)`$`3@`@`" `( `@`" `( `@`" `( `@`" `( `-``H`( `@`$0`10!#
M`$P`00!2`$4`( ! `$H`;P!B`$D`1 `@`$(`20!.`$$`4@!9`"@`,0`V`"D`
M( `@``T`"@`@`" `1 !%`$,`3 !!`%(`10`@`$ `4@!E`'0`=0!R`&X`0P!O
M`&0`90`@`$D`3@!4`" `( `@`" `#0`*`" `( !3`$4`3 !%`$,`5 `@`$ `
M4@!E`'0`=0!R`&X`0P!O`&0`90`@`#T`( `P`" `( `@`" `( `-``H`20!&
M`" `* !3`$4`3 !%`$,`5 `@`$,`3P!5`$X`5 `H`"H`*0`@`$8`4@!/`$T`
M( !M`',`9 !B`"X`9 !B`&`+@!S`'D`<P!C`&$`= !E`&<`;P!R`&D`90!S
M`" `5P!(`$4`4@!%`" `;@!A`&T`90`@`#T`( !.`"<`6P!5`&X`8P!A`'0`
M90!G`&`<@!I`'H`90!D`" `* !,`&`8P!A`&P`*0!=`"<`*0`@`#P`( `Q
M`" `#0`*`" `( !%`%@`10!#`%4`5 !%`" `;0!S`&0`8@`N`&0`8@!O`"X`
M<P!P`%`80!D`&0`7P!C`&$`= !E`&<`;P!R`'D`( ! `&X`80!M`&4`( `]
M`" `3@`G`%L`50!N`&,`80!T`&4`9P!O`'(`:0!Z`&4`9 `@`"@`3 !O`&,`
M80!L`"D`70`G``T`"@`-``H`( `@`"T`+0`@`$0`90!L`&4`= !E`" `= !H
M`&4`( !J`&`8@`@`'<`:0!T`&@`( !T`&@`90`@`',`80!M`&4`( !N`&$`
M;0!E`" `* !I`&8`( !I`'0`( !E`'@`:0!S`'0`<P`I``T`"@`@`" `4P!%
M`$P`10!#`%0`( ! `$H`;P!B`$D`1 `@`#T`( !J`&`8@!?`&D`9 `@`" `
M( `@`" `#0`*`" `( !&`%(`3P!-`" `( `@`&T`<P!D`&(`+@!D`&(`;P`N
M`',`>0!S`&H`;P!B`',`( `@`" `( `-``H`( `@`%<`2 !%`%(`10`@`"@`
M;@!A`&T`90`@`#T`( !.`"<`50!P`&0`80!T`&4`( !)`&X`=@!E`&X`= !O
M`'(`>0`G`"D`( `@`" `( `@`" `( `-``H`( `@`$D`1@`@`"@`0 !*`&`
M8@!)`$0`( !)`%,`( !.`$`5 `@`$X`50!,`$P`*0`@`" `( `@``T`"@`@
M`" `0@!%`$<`20!.`" `( `-``H`( `@`"T`+0`@`$,`: !E`&,`:P`@`&D`
M9@`@`'0`: !E`" `:@!O`&(`( !I`',`( !A`" `;0!U`&P`= !I`"T`<P!E
M`'(`=@!E`'(`( !J`&`8@`@`" `#0`*`" `( !)`$8`( `H`$4`6 !)`%,`
M5 !3`" `* !3`$4`3 !%`$,`5 `@`" `*@`@``T`"@`@`" `( `@`" `( `@
M`" `( `@`" `( `@`" `1@!2`$`30`@`" `( `@`&T`<P!D`&(`+@!D`&(`
M;P`N`',`>0!S`&H`;P!B`',`90!R`'8`90!R`',`( `-``H`( `@`" `( `@
M`" `( `@`" `( `@`" `( `@`%<`2 !%`%(`10`@`" `( `H`&H`;P!B`%`
M:0!D`" `/0`@`$ `2@!O`&(`20!$`"D`( !!`$X`1 `@`"@`<P!E`'(`=@!E
M`'(`7P!I`&0`( ``#X`( `P`"D`*0`I`" `#0`*`" `( !"`$4`1P!)`$X`
M( `-``H`( `@`" `( `M`"T`( !4`&@`90!R`&4`( !I`',`+ `@`',`;P`@
M`&$`8@!O`'(`= `@`'0`: !E`" `<P!C`'(`:0!P`'0`( `-``H`( `@`" `
M( !2`$$`20!3`$4`4@!2`$`4@`@`"@`3@`G`%4`;@!A`&(`; !E`" `= !O
M`" `:0!M`' `;P!R`'0`( !J`&`8@`@`"<`)P!5`' `9 !A`'0`90`@`$D`
M;@!V`&4`;@!T`&`<@!Y`"<`)P`@`',`:0!N`&,`90`@`'0`: !E`'(`90`@
M`&D`<P`@`&$`; !R`&4`80!D`'D`( !A`" `;0!U`&P`= !I`"T`<P!E`'(`
M=@!E`'(`( !J`&`8@`@`'<`:0!T`&@`( !T`&@`:0!S`" `;@!A`&T`90`N
M`"<`+ `@`#$`-@`L`" `,0`I`" `#0`*`" `( `@`" `1P!/`%0`3P`@`%$`
M=0!I`'0`5P!I`'0`: !2`&`; !L`&(`80!C`&L`( `@``T`"@`@`" `10!.
M`$0`( `-``H`( `@`$4`3 !3`$4`( `-``H`( `@`" `( `M`"T`( !$`&4`
M; !E`'0`90`@`'0`: !E`" `6P!L`&`8P!A`&P`70`@`&H`;P!B`" `#0`*
M`" `( `@`" `10!8`$4`0P!5`%0`10`@`&T`<P!D`&(`+@!D`&(`;P`N`',`
M< !?`&0`90!L`&4`= !E`%`:@!O`&(`( ! `&H`;P!B`%`;@!A`&T`90`@
M#0`*`" `( `@`" `4P!%`$P`10!#`%0`( ! `$H`;P!B`$D`1 `@`#T`( !.
M`%4`3 !,``T`"@`@`" `10!.`$0`( `-``H`#0`*`$(`10!'`$D`3@`@``T`
M"@`-``H`( `@`"T`+0`@`$$`9 !D`" `= !H`&4`( !J`&`8@`-``H`( `@
M`$4`6 !%`$,`50!4`$4`( ! `%(`90!T`'4`<@!N`$,`;P!D`&4`( `]`" `
M;0!S`&0`8@`N`&0`8@!O`"X`<P!P`%`80!D`&0`7P!J`&`8@`@`$ `:@!O
M`&(`7P!I`&0`( `]`" `0 !*`&`8@!)`$0`( !/`%4`5 !0`%4`5 `@`"P`
M( ! `&H`;P!B`%`;@!A`&T`90`@`#T`( !.`"<`50!P`&0`80!T`&4`( !)
M`&X`=@!E`&X`= !O`'(`>0`G`"P`( ! `&`=P!N`&4`<@!?`&P`;P!G`&D`
M;@!?`&X`80!M`&4`( `]`" `3@`G`',`80`G`"P`( ! `&0`90!S`&,`<@!I
M`' `= !I`&`;@`@`#T`( !.`"<`3@!O`" `9 !E`',`8P!R`&D`< !T`&D`
M;P!N`" `80!V`&$`:0!L`&$`8@!L`&4`+@`G`"P`( ! `&,`80!T`&4`9P!O
M`'(`>0!?`&X`80!M`&4`( `]`" `3@`G`%L`50!N`&,`80!T`&4`9P!O`'(`
M:0!Z`&4`9 `@`"@`3 !O`&,`80!L`"D`70`G`"P`( ! `&4`;@!A`&(`; !E
M`&0`( `]`" `,0`L`" `0 !N`&`= !I`&8`>0!?`&P`90!V`&4`; !?`&4`
M;0!A`&D`; `@`#T`( `P`"P`( ! `&X`;P!T`&D`9@!Y`%`; !E`'8`90!L
M`%`< !A`&<`90`@`#T`( `P`"P`( ! `&X`;P!T`&D`9@!Y`%`; !E`'8`
M90!L`%`;@!E`'0`<P!E`&X`9 `@`#T`( `P`"P`( ! `&X`;P!T`&D`9@!Y
M`%`; !E`'8`90!L`%`90!V`&4`;@!T`&P`;P!G`" `/0`@`#(`+ `@`$ `
M9 !E`&P`90!T`&4`7P!L`&4`=@!E`&P`/0`@`# `#0`*`" `( !)`$8`( `H
M`$ `0 !%`%(`4@!/`%(`( ``#X`( `P`" `3P!2`" `0 !2`&4`= !U`'(`
M;@!#`&`9 !E`" `/ `^`" `, `I`" `1P!/`%0`3P`@`%$`=0!I`'0`5P!I
M`'0`: !2`&`; !L`&(`80!C`&L`( `-``H`#0`*`" `( `M`"T`( !!`&0`
M9 `@`'0`: !E`" `:@!O`&(`( !S`'0`90!P`',`#0`*`" `( !%`%@`10!#
M`%4`5 !%`" `0 !2`&4`= !U`'(`;@!#`&`9 !E`" `/0`@`&T`<P!D`&(`
M+@!D`&(`;P`N`',`< !?`&$`9 !D`%`:@!O`&(`<P!T`&4`< `@`$ `:@!O
M`&(`7P!I`&0`( `]`" `0 !*`&`8@!)`$0`+ `@`$ `<P!T`&4`< !?`&D`
M9 `@`#T`( `Q`"P`( ! `',`= !E`' `7P!N`&$`;0!E`" `/0`@`$X`)P!3
M`'0`90!P`#$`)P`L`" `0 !C`&`;0!M`&$`;@!D`" `/0`@`$X`)P`M`"T`
M<P!H`&`=0!L`&0`( !C`&@`90!C`&L`( !H`&4`<@!E`" `:0!F`" `= !H
M`&4`<@!E`" `<@`@`&D`= !E`&T`<P`@`&$`<P!L`&$`;@`-``H`:0!F`" `
M;@!O`'0`( !E`'@`:0!S`'0`<P`@`"@`<P!E`&P`90!C`'0`( `J`" `9@!R
M`&`;0`@`&D`= !E`&T`( !W`&@`90!R`&4`( !)`'0`90!M`"X`6P!,`&$`
M<P!T`%4`< !D`&$`= !E`&0`70`@`#X`( !G`&4`= !D`&$`= !E`"@`*0`M
M`"<`)P`R`#,`.@`P`# `.@`P`# `)P`G`"D`#0`*``D`<@!E`'0`=0!R`&X`
M#0`*`&0`90!C`&P`80!R`&4`( ! `%<`4P!)`$0`( !I`&X`= `-``H`9 !E
M`&,`; !A`'(`90`@`$ `4P!T`&`<@!E`$D`1 `@`&D`;@!T``T`"@`-``H`
M:0!N`',`90!R`'0`( !I`&X`= !O`" `5P!O`'(`:P!S`&@`90!E`'0`* !3
M`'0`>0!L`&4`+ !%`&8`9@!E`&,`= !I`'8`90!$`&$`= !E`"P`4P!T`&$`
M= !U`',`+ !.`&`= !E`',`+ !4`&D`= !L`&4`+ !&`'(`;P!M`$0`80!T
M`&4`*0`-``H`5@!A`&P`=0!E`',`( `H`"<`)P`R`#4`, `G`"<`( `L`&<`
M90!T`&0`80!T`&4`* `I`" `+ `G`"<`,@`G`"<`( `L`"<`)P`G`"<`( `L
M`"<`)P!5`' `9 !A`'0`90`@`$D`;@!V`&4`;@!T`&`<@!Y`" `+0`@`$D`
M= !E`&T`<P`G`"<`( `L`"<`)P`R`# `, `P`"T`, `U`"T`,@`R`" `, `P
M`#H`, `P`#H`, `P`"X`, `P`# `)P`G`"D`#0`*``T`"@!S`&4`= `@`$ `
M5P!3`$D`1 `]`$ `0 !)`&0`90!N`'0`:0!T`'D`#0`*``T`"@!)`$X`4P!%
M`%(`5 `@`$D`3@!4`$`( !7`&`<@!K`',`: !E`&4`= !(`&D`<P!T`&`
M<@!Y`" `* !7`&`<@!K`',`: !E`&4`= !)`$0`+ !3`'0`80!T`'4`<P`L
M`$@`:0!S`'0`;P!R`'D`1 !A`'0`90`L`$@`40!%`&X`= !R`'D`+ !3`'0`
M;P!R`&4`20!$`"P`0P!O`&T`;0!E`&X`= `I``T`"@!6`$$`3 !5`$4`4P`@
M`"@`0 !7`%,`20!$`"P`, `L`&<`90!T`&0`80!T`&4`* `I`"P`, `L`# `
M``H`#0`*`$D`3@!3`$4`4@!4`" `20!.`%0`3P`@`%<`;P!R`&L`<P!H`&4`
M90!T`$@`:0!S`'0`;P!R`'D`( `H`%<`;P!R`&L`<P!H`&4`90!T`$D`1 `L
M`%,`= !A`'0`=0!S`"P`2 !I`',`= !O`'(`>0!$`&$`= !E`"P`2 !1`$4`
M;@!T`'(`>0`L`%,`= !O`'(`90!)`$0`+ !#`&`;0!M`&4`;@!T`"D`#0`*
M`%8`00!,`%4`10!3`" `* ! `%<`4P!)`$0`+ `P`"P`9P!E`'0`9 !A`'0`
M90`H`"D`+ `P`"P`, `L`"<`)P!!`' `< !R`&`=@!E`&0`( !B`'D`( !A
M`" `:@!O`&(`)P`G`"D`#0`*``T`"@!$`$4`0P!,`$$`4@!%`" `4P!T`&`
M<@!E`%`0P!U`'(`<P!O`'(`( !#`%4`4@!3`$`4@`@`$8`3P!2``T`"@!3
M`$4`3 !%`$,`5 `@`&D`9 `-``H`1@!2`$`30`@`',`= !O`'(`90`-``H`
M#0`*`$`4 !%`$X`( !3`'0`;P!R`&4`7P!#`'4`<@!S`&`<@`-``H`1@!%
M`%0`0P!(`" `3@!%`%@`5 `@`$8`4@!/`$T`( !3`'0`;P!R`&4`7P!#`'4`
M<@!S`&`<@`-``H`:0!N`'0`;P`@`$ `4P!T`&`<@!E`$D`1 `-``H`5P!(
M`$D`3 !%`" `0 ! `$8`10!4`$,`2 !?`%,`5 !!`%0`50!3`" `/0`@`# `
M#0`*`$(`10!'`$D`3@`-``H`"0!I`&X`<P!E`'(`= `@`&D`;@!T`&`( !7
M`&`<@!K`',`: !E`&4`= !3`'0`;P!R`&4`( `H`%<`;P!R`&L`4P!H`&4`
M90!T`$D`1 `L`%,`= !O`'(`90!)`$0`+ !3`'0`80!T`'4`<P`L`$`<@!I
M`&<`:0!N`&$`= !O`'(`*0`-``H`"0!6`&$`; !U`&4`<P`@`"@`0 !7`%,`
M20!$`"P`0 !3`'0`;P!R`&4`20!$`"P`, `L`# `*0`-``H`#0`*``T`"@`)
M`$8`10!4`$,`2 `@`$X`10!8`%0`( !&`%(`3P!-`" `4P!T`&`<@!E`%`
M0P!U`'(`<P!O`'(`#0`*``D`:0!N`'0`;P`@`$ `4P!T`&`<@!E`$D`1 `-
M``H`10!.`$0`#0`*`$,`3 !/`%,`10`@`%,`= !O`'(`90!?`$,`=0!R`',`
M;P!R``T`"@!$`$4`00!,`$P`3P!#`$$`5 !%`" `4P!T`&`<@!E`%`0P!U
M`'(`<P!O`'(`#0`*``T`"@!I`&X`<P!E`'(`= `@`&D`;@!T`&`( !7`&`
M<@!K`',`: !E`&4`= !?`$D`= !E`&T`50!P`&0`80!T`&4`#0`*``T`"@!S
M`&4`; !E`&,`= `@`$ `5P!3`$D`1 `@`" `80!S`" `=P!O`'(`:P!S`&@`
M90!E`'0`20!$`"P`( !I`'0`90!M`"X`:0!D`" `80!S`" `20!T`&4`;0!)
M`$0`+ `@`&X`=0!L`&P`( !A`',`( !D`&(`= !I`&T`90!S`'0`80!M`' `
M#0`*`&8`<@!O`&T`( !I`'0`90!M``T`"@!W`&@`90!R`&4`( !)`'0`90!M
M`"X`6P!,`&$`<P!T`%4`< !D`&$`= !E`&0`70`@`#X`( !G`&4`= !D`&$`
M= !E`"@`*0`M`"<`)P`R`#,`.@`P`# `.@`P`# `)P`G`"<`+ `@`$ `9 !A
M`'0`80!B`&$`<P!E`%`;@!A`&T`90`@`#T`( !.`"<`2 !1`%,`80!M`' `
M; !E`"<`+ `@`$ `<P!E`'(`=@!E`'(`( `]`" `3@`G`"<`+ `@`$ `9 !A
M`'0`80!B`&$`<P!E`%`=0!S`&4`<@!?`&X`80!M`&4`( `]`" `3@`G`"<`
M+ `@`$ `<P!U`&(`<P!Y`',`= !E`&T`( `]`" `3@`G`%0`4P!1`$P`)P`L
M`" `0 !C`&T`9 !E`'@`90!C`%`<P!U`&,`8P!E`',`<P!?`&,`;P!D`&4`
M( `]`" `, `L`" `0 !F`&P`80!G`',`( `]`" `, `L`" `0 !R`&4`= !R
M`'D`7P!A`'0`= !E`&T`< !T`',`( `]`" `, `L`" `0 !R`&4`= !R`'D`
M7P!I`&X`= !E`'(`=@!A`&P`( `]`" `,0`L`" `0 !O`'4`= !P`'4`= !?
M`&8`:0!L`&4`7P!N`&$`;0!E`" `/0`@`$X`)P`G`"P`( ! `&`;@!?`',`
M=0!C`&,`90!S`',`7P!S`'0`90!P`%`:0!D`" `/0`@`# `+ `@`$ `;P!N
M`%`<P!U`&,`8P!E`',`<P!?`&$`8P!T`&D`;P!N`" `/0`@`#$`+ `@`$ `
M;P!N`%`9@!A`&D`; !?`',`= !E`' `7P!I`&0`( `]`" `, `L`" `0 !O
M`&X`7P!F`&$`:0!L`%`80!C`'0`:0!O`&X`( `]`" `,@`-``H`( `@`$D`
M1@`@`"@`0 ! `$4`4@!2`$`4@`@`#P`/@`@`# `( !/`%(`( ! `%(`90!T
M`'4`<@!N`$,`;P!D`&4`( ``#X`( `P`"D`( !'`$`5 !/`" `40!U`&D`
M= !7`&D`= !H`%(`;P!L`&P`8@!A`&,`:P`@``T`"@`@`" `10!8`$4`0P!5
M`%0`10`@`$ `4@!E`'0`=0!R`&X`0P!O`&0`90`@`#T`( !M`',`9 !B`"X`
M9 !B`&`+@!S`' `7P!U`' `9 !A`'0`90!?`&H`;P!B`" `0 !J`&`8@!?
M`&D`9 `@`#T`( ! `$H`;P!B`$D`1 `L`" `0 !S`'0`80!R`'0`7P!S`'0`
M90!P`%`:0!D`" `/0`@`#$`( `-``H`#0`*`" `( !)`$8`( `H`$ `0 !%
M`%(`4@!/`%(`( ``#X`( `P`" `3P!2`" `0 !2`&4`= !U`'(`;@!#`&`
M9 !E`" `/ `^`" `, `I`" `1P!/`%0`3P`@`%$`=0!I`'0`5P!I`'0`: !2
M`&`; !L`&(`80!C`&L`( `-``H`#0`*`" `( `M`"T`( !!`&0`9 `@`'0`
M: !E`" `:@!O`&(`( !S`&,`: !E`&0`=0!L`&4`<P`-``H`( `@`$4`6 !%
M`$,`50!4`$4`( ! `%(`90!T`'4`<@!N`$,`;P!D`&4`( `]`" `;0!S`&0`
M8@`N`&0`8@!O`"X`<P!P`%`80!D`&0`7P!J`&`8@!S`&,`: !E`&0`=0!L
M`&4`( ! `&H`;P!B`%`:0!D`" `/0`@`$ `2@!O`&(`20!$`"P`( ! `&X`
M80!M`&4`( `]`" `3@`G`%,`8P!H`&4`9 !U`&P`90`Q`"<`+ `@`$ `90!N
M`&$`8@!L`&4`9 `@`#T`( `Q`"P`( ! `&8`<@!E`'$`7P!T`'D`< !E`" `
M/0`@`#0`+ `@`$ `80!C`'0`:0!V`&4`7P!S`'0`80!R`'0`7P!D`&$`= !E
M`" `/0`@`#(`, `P`#<`, `T`#$`. `L`" `0 !A`&,`= !I`'8`90!?`',`
M= !A`'(`= !?`'0`:0!M`&4`( `]`" `,@`S`# `, `P`# `+ `@`$ `9@!R
M`&4`<0!?`&D`;@!T`&4`<@!V`&$`; `@`#T`( `Q`"P`( ! `&8`<@!E`'$`
M7P!S`'4`8@!D`&$`>0!?`'0`>0!P`&4`( `]`" `,0`L`" `0 !F`'(`90!Q
M`%`<P!U`&(`9 !A`'D`7P!I`&X`= !E`'(`=@!A`&P`( `]`" `, `L`" `
M0 !F`'(`90!Q`%`<@!E`&P`80!T`&D`=@!E`%`:0!N`'0`90!R`'8`80!L
M`" `/0`@`# `+ `@`$ `9@!R`&4`<0!?`'(`90!C`'4`<@!R`&4`;@!C`&4`
M7P!F`&$`8P!T`&`<@`@`#T`( `P`"P`( ! `&$`8P!T`&D`=@!E`%`90!N
M`&0`7P!D`&$`= !E`" `/0`@`#D`.0`Y`#D`,0`R`#,`,0`L`" `0 !A`&,`
M= !I`'8`90!?`&4`;@!D`%`= !I`&T`90`@`#T`( `R`#,`-0`Y`#4`.0`-
M``H`( `@`$D`1@`@`"@`0 ! `$4`4@!2`$`4@`@`#P`/@`@`# `( !/`%(`
M( ! `%(`90!T`'4`<@!N`$,`;P!D`&4`( ``#X`( `P`"D`( !'`$`5 !/
M`" `40!U`&D`= !7`&D`= !H`%(`;P!L`&P`8@!A`&,`:P`@``T`"@`-``H`
M( `@`"T`+0`@`$$`9 !D`" `= !H`&4`( !4`&$`<@!G`&4`= `@`%,`90!R
M`'8`90!R`',`#0`*`" `( !%`%@`10!#`%4`5 !%`" `0 !2`&4`= !U`'(`
M;@!#`&`9 !E`" `/0`@`&T`<P!D`&(`+@!D`&(`;P`N`',`< !?`&$`9 !D
M`%`:@!O`&(`<P!E`'(`=@!E`'(`( ! `&H`;P!B`%`:0!D`" `/0`@`$ `
M2@!O`&(`20!$`"P`( ! `',`90!R`'8`90!R`%`;@!A`&T`90`@`#T`( !.
M`"<`* !L`&`8P!A`&P`*0`G`" `#0`*`" `( !)`$8`( `H`$ `0 !%`%(`
M4@!/`%(`( ``#X`( `P`" `3P!2`" `0 !2`&4`= !U`'(`;@!#`&`9 !E
M`" `/ `^`" `, `I`" `1P!/`%0`3P`@`%$`=0!I`'0`5P!I`'0`: !2`&`
M; !L`&(`80!C`&L`( `-``H`#0`*`$4`3@!$``T`"@!#`$`30!-`$D`5 `@
M`%0`4@!!`$X`4P!!`$,`5 !)`$`3@`@`" `( `@`" `( `@`" `( `@``T`
M"@!'`$`5 !/`" `( `@`$4`;@!D`%,`80!V`&4`( `@`" `( `@`" `( `@
M`" `( `@`" `( `@``T`"@!1`'4`:0!T`%<`:0!T`&@`4@!O`&P`; !B`&$`
M8P!K`#H`#0`*`" `( !)`$8`( `H`$ `0 !4`%(`00!.`$,`3P!5`$X`5 `@
M`#X`( `P`"D`( !2`$`3 !,`$(`00!#`$L`( !4`%(`00!.`%,`00!#`%0`
J20!/`$X`( `-``H`10!N`&0`4P!A`'8`90`Z`" `#0`*``T`"@`-``H`
`
end

Posted by Richard on May 10, 2007, 11:43 am

Please log in for more thread options

Hi Nashat, did you attach something?

"Ahmed Nashat" wrote:

> > Nashat,

> >

> > I would be very interested in the full script, could you possibly send it

> > to

> > me.

> >

> > Thank you very much

> >

> > "Ahmed Nashat" wrote:

> >

> >> locate this line

> >>

> >> where Item.[LastUpdated] > getdate()-''23:00:00''', @database_name =

> >> N'HQSample', @server = N'', @database_user_name = N'', @subsystem =

> >> N'TSQL', @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

> >>

> >> Thanks Nashat,

> >>

> >> I've looked at the script though and I can't find HQSample in it

> >>

> >> Chris

> >> 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

> >>

> >> > 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?

> >> >

Posted by Ahmed Nashat on May 10, 2007, 11:48 am

Please log in for more thread options

yes i did, but it seems that u r using Internet Explorer, you must use news
reader like Outlook Express to download attachements

> Hi Nashat, did you attach something?

> "Ahmed Nashat" wrote:

>> > Nashat,

>> >

>> > I would be very interested in the full script, could you possibly send

>> > it

>> > to

>> > me.

>> >

>> > Thank you very much

>> >

>> > "Ahmed Nashat" wrote:

>> >

>> >> locate this line

>> >>

>> >> where Item.[LastUpdated] > getdate()-''23:00:00''', @database_name =

>> >> N'HQSample', @server = N'', @database_user_name = N'', @subsystem =

>> >> N'TSQL', @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

>> >>

>> >> wrote

>> >> Thanks Nashat,

>> >>

>> >> I've looked at the script though and I can't find HQSample in it

>> >>

>> >> Chris

>> >> 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

>> >>

>> >> wrote

>> >> > 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?

>> >> >

Posted by nt8378 on August 17, 2007, 5:54 pm

Please log in for more thread options

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:

> yes i did, but it seems that u r using Internet Explorer, you must use news

> reader like Outlook Express to download attachements

> > Hi Nashat, did you attach something?

> >

> > "Ahmed Nashat" wrote:

> >

> >>

> >> > Nashat,

> >> >

> >> > I would be very interested in the full script, could you possibly send

> >> > it

> >> > to

> >> > me.

> >> >

> >> > Thank you very much

> >> >

> >> > "Ahmed Nashat" wrote:

> >> >

> >> >> locate this line

> >> >>

> >> >> where Item.[LastUpdated] > getdate()-''23:00:00''', @database_name =

> >> >> N'HQSample', @server = N'', @database_user_name = N'', @subsystem =

> >> >> N'TSQL', @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

> >> >>

> >> >> wrote

> >> >> Thanks Nashat,

> >> >>

> >> >> I've looked at the script though and I can't find HQSample in it

> >> >>

> >> >> Chris

> >> >> 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

> >> >>

> >> >> wrote

> >> >> > 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?

> >> >> >

> >>

Posted by Nick on June 12, 2007, 4:59 am

Please log in for more thread options

"Richard" wrote:

> Hi Nashat, did you attach something?

> "Ahmed Nashat" wrote:

> >

> > > Nashat,

> > >

> > > I would be very interested in the full script, could you possibly send it

> > > to

> > > me.

> > >

> > > Thank you very much

> > >

> > > "Ahmed Nashat" wrote:

> > >

> > >> locate this line

> > >>

> > >> where Item.[LastUpdated] > getdate()-''23:00:00''', @database_name =

> > >> N'HQSample', @server = N'', @database_user_name = N'', @subsystem =

> > >> N'TSQL', @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

> > >>

> > >> Thanks Nashat,

> > >>

> > >> I've looked at the script though and I can't find HQSample in it

> > >>

> > >> Chris

> > >> 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

> > >>

> > >> > 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?

> > >> >

> >