I have a report that uses execution snapshots but for some reason the
snapshots don't seem to be executing.
I used 'Render this report from an execution snapshot'
'Use the following schedule to create exection snapshot'
and configured it to create a snapshot everyhour.
but I don't receive a notification every hour. (As a test I wanted it to
notify me of updated snapshots).
The only time it seems to work is when I check 'Create a snapshot of the
report when the apply button is selected'
Is there anything I shoud check to make sure scheduled snapshots work?
JacksonI've been doing some more testing and it seems like it doesn't do scheduling
for odbc connections to access databases. The snapshot schedule works fine
with SQL but doesn't seem to do anything for access databases.
Is there anyway possible to schedule snapshots for an access database?
TIA,
Jackson
"Jackson" <jackson_num5@.yahoo.com> wrote in message
news:essnC6SvFHA.2504@.tk2msftngp13.phx.gbl...
>I have a report that uses execution snapshots but for some reason the
>snapshots don't seem to be executing.
> I used 'Render this report from an execution snapshot'
> 'Use the following schedule to create exection snapshot'
> and configured it to create a snapshot everyhour.
> but I don't receive a notification every hour. (As a test I wanted it to
> notify me of updated snapshots).
> The only time it seems to work is when I check 'Create a snapshot of the
> report when the apply button is selected'
> Is there anything I shoud check to make sure scheduled snapshots work?
> Jackson
>
Showing posts with label execution. Show all posts
Showing posts with label execution. Show all posts
Wednesday, March 21, 2012
Scheduled Programmatic Printing
I have searched this site and the internet but can not find and article or
discussion related to a means of scheduling the execution of a report and
have the report programmatically printed. Does anyone else have such a need
and how have they approached such a solution?
TIA RonHi,
Books online have an example of how you can set up a printer as an output
destination for subscriptions.
Once the printer has been setup up in RS, you can simply set up a data
driven subscription in the standard way and point it to your printer.
Gavin
"Ron Schmidt" wrote:
> Rob -- Thanks for the response.
> We actually have done neither at this time. We are attempting to
> "convert/replace" a number of Unix based reports that are currently being
> executed via functions on a Tandem system. The current reports are
> scheduled, executed and the output sent to a specific networked printer. We
> have developed a few simple scheduled reports and a few ad hoc parameter
> driven reports, but were puzzled as to how we could have a "production"
> scheduled report that would execute unattended and print to a designated
> printer. It looks like we may have to create a separate executable and
> explore how the executable can print to a specific printer.
> Thanks again
> Ron
> "Rob Nelder" <RobNelder@.discussions.microsoft.com> wrote in message
> news:5F7DE303-A8AF-4D63-A1EF-4AF3A7A8F0CB@.microsoft.com...
> > Ron,
> >
> > Is it the scheduling or the programmatic printing that you're having
> > trouble
> > with?
> >
> > If you've written your own code to print reports, have you done it as a
> > report rendering extension, or as a separate executable/DLL?
> >
> > If the former, I think you should be able to schedule the report from
> > Report
> > Manager. If the later, you'll need to either schedule your code to run
> > using
> > the Windows Scheduler (or some equivalent), or have your code running
> > permanently as a Windows Service so that it can schedule the printing its
> > self.
> >
> > Cheers,
> > Rob
> >
> > "Ron Schmidt" wrote:
> >
> >> I have searched this site and the internet but can not find and article
> >> or
> >> discussion related to a means of scheduling the execution of a report and
> >> have the report programmatically printed. Does anyone else have such a
> >> need
> >> and how have they approached such a solution?
> >>
> >>
> >>
> >> TIA Ron
> >>
> >>
> >>
>
>|||Ron,
Is it the scheduling or the programmatic printing that you're having trouble
with?
If you've written your own code to print reports, have you done it as a
report rendering extension, or as a separate executable/DLL?
If the former, I think you should be able to schedule the report from Report
Manager. If the later, you'll need to either schedule your code to run using
the Windows Scheduler (or some equivalent), or have your code running
permanently as a Windows Service so that it can schedule the printing its
self.
Cheers,
Rob
"Ron Schmidt" wrote:
> I have searched this site and the internet but can not find and article or
> discussion related to a means of scheduling the execution of a report and
> have the report programmatically printed. Does anyone else have such a need
> and how have they approached such a solution?
>
> TIA Ron
>
>|||Rob -- Thanks for the response.
We actually have done neither at this time. We are attempting to
"convert/replace" a number of Unix based reports that are currently being
executed via functions on a Tandem system. The current reports are
scheduled, executed and the output sent to a specific networked printer. We
have developed a few simple scheduled reports and a few ad hoc parameter
driven reports, but were puzzled as to how we could have a "production"
scheduled report that would execute unattended and print to a designated
printer. It looks like we may have to create a separate executable and
explore how the executable can print to a specific printer.
Thanks again
Ron
"Rob Nelder" <RobNelder@.discussions.microsoft.com> wrote in message
news:5F7DE303-A8AF-4D63-A1EF-4AF3A7A8F0CB@.microsoft.com...
> Ron,
> Is it the scheduling or the programmatic printing that you're having
> trouble
> with?
> If you've written your own code to print reports, have you done it as a
> report rendering extension, or as a separate executable/DLL?
> If the former, I think you should be able to schedule the report from
> Report
> Manager. If the later, you'll need to either schedule your code to run
> using
> the Windows Scheduler (or some equivalent), or have your code running
> permanently as a Windows Service so that it can schedule the printing its
> self.
> Cheers,
> Rob
> "Ron Schmidt" wrote:
>> I have searched this site and the internet but can not find and article
>> or
>> discussion related to a means of scheduling the execution of a report and
>> have the report programmatically printed. Does anyone else have such a
>> need
>> and how have they approached such a solution?
>>
>> TIA Ron
>>
discussion related to a means of scheduling the execution of a report and
have the report programmatically printed. Does anyone else have such a need
and how have they approached such a solution?
TIA RonHi,
Books online have an example of how you can set up a printer as an output
destination for subscriptions.
Once the printer has been setup up in RS, you can simply set up a data
driven subscription in the standard way and point it to your printer.
Gavin
"Ron Schmidt" wrote:
> Rob -- Thanks for the response.
> We actually have done neither at this time. We are attempting to
> "convert/replace" a number of Unix based reports that are currently being
> executed via functions on a Tandem system. The current reports are
> scheduled, executed and the output sent to a specific networked printer. We
> have developed a few simple scheduled reports and a few ad hoc parameter
> driven reports, but were puzzled as to how we could have a "production"
> scheduled report that would execute unattended and print to a designated
> printer. It looks like we may have to create a separate executable and
> explore how the executable can print to a specific printer.
> Thanks again
> Ron
> "Rob Nelder" <RobNelder@.discussions.microsoft.com> wrote in message
> news:5F7DE303-A8AF-4D63-A1EF-4AF3A7A8F0CB@.microsoft.com...
> > Ron,
> >
> > Is it the scheduling or the programmatic printing that you're having
> > trouble
> > with?
> >
> > If you've written your own code to print reports, have you done it as a
> > report rendering extension, or as a separate executable/DLL?
> >
> > If the former, I think you should be able to schedule the report from
> > Report
> > Manager. If the later, you'll need to either schedule your code to run
> > using
> > the Windows Scheduler (or some equivalent), or have your code running
> > permanently as a Windows Service so that it can schedule the printing its
> > self.
> >
> > Cheers,
> > Rob
> >
> > "Ron Schmidt" wrote:
> >
> >> I have searched this site and the internet but can not find and article
> >> or
> >> discussion related to a means of scheduling the execution of a report and
> >> have the report programmatically printed. Does anyone else have such a
> >> need
> >> and how have they approached such a solution?
> >>
> >>
> >>
> >> TIA Ron
> >>
> >>
> >>
>
>|||Ron,
Is it the scheduling or the programmatic printing that you're having trouble
with?
If you've written your own code to print reports, have you done it as a
report rendering extension, or as a separate executable/DLL?
If the former, I think you should be able to schedule the report from Report
Manager. If the later, you'll need to either schedule your code to run using
the Windows Scheduler (or some equivalent), or have your code running
permanently as a Windows Service so that it can schedule the printing its
self.
Cheers,
Rob
"Ron Schmidt" wrote:
> I have searched this site and the internet but can not find and article or
> discussion related to a means of scheduling the execution of a report and
> have the report programmatically printed. Does anyone else have such a need
> and how have they approached such a solution?
>
> TIA Ron
>
>|||Rob -- Thanks for the response.
We actually have done neither at this time. We are attempting to
"convert/replace" a number of Unix based reports that are currently being
executed via functions on a Tandem system. The current reports are
scheduled, executed and the output sent to a specific networked printer. We
have developed a few simple scheduled reports and a few ad hoc parameter
driven reports, but were puzzled as to how we could have a "production"
scheduled report that would execute unattended and print to a designated
printer. It looks like we may have to create a separate executable and
explore how the executable can print to a specific printer.
Thanks again
Ron
"Rob Nelder" <RobNelder@.discussions.microsoft.com> wrote in message
news:5F7DE303-A8AF-4D63-A1EF-4AF3A7A8F0CB@.microsoft.com...
> Ron,
> Is it the scheduling or the programmatic printing that you're having
> trouble
> with?
> If you've written your own code to print reports, have you done it as a
> report rendering extension, or as a separate executable/DLL?
> If the former, I think you should be able to schedule the report from
> Report
> Manager. If the later, you'll need to either schedule your code to run
> using
> the Windows Scheduler (or some equivalent), or have your code running
> permanently as a Windows Service so that it can schedule the printing its
> self.
> Cheers,
> Rob
> "Ron Schmidt" wrote:
>> I have searched this site and the internet but can not find and article
>> or
>> discussion related to a means of scheduling the execution of a report and
>> have the report programmatically printed. Does anyone else have such a
>> need
>> and how have they approached such a solution?
>>
>> TIA Ron
>>
Tuesday, March 20, 2012
scheduled job runs forewer
Hello,
I have scheduled job that are scheduled to run every 2 hours.
Its exec stored procedures. Normal execution time is up to 10 min.
But recently job not running successfully, its just executes forever. So I had to kill that job and I run it manually.
Please help,
I have no idea why it stops executing on its own by the schedule.
Thank you,did you use sp_who2 to see if it is blocked?
did you use dbcc_inputbuffer or sql_handle to see if the code executing changed?
did you create an output file in the job scheduler to capture output from the job steps?
did you change the procs to write to the output file as each starts, runs, and ends?
did you logically think "what can i do to troubleshoot this issue?"
did you google for similar situations?
did you look at the "sticky" at the top of the forum to see what you might need to add to your post to help us help you?|||Thank you for all of the suggestions you have for me.
I will try them one by one.|||How about trying one of the easiest things, stop and start the sql agent. Sometimes the scheduler gets wacked out and a simple stop and start will fix it.|||Does the code contains loops or cursors?|||Does the code contains loops or cursors?
while (1=1)
begin
print 'probably'
end|||The procedure does contain cursors and it runs Ok via SQL Query Analyzer, but once I add it up to SQL Server Agent Job it takes forever...
I do have an output file to capture output from the job steps, but since the job never been completed, and I had to kill it, there are no completion info.
If I will stop and start the sql agent before execution of this job, how the other scheduled processes be affected by that?
Thank you|||Whatever other issues may be occurring, step #1 is to drop the cursors and use set-based operations.|||Unless the jobs sends separate e-mails to employees, for example...|||The procedure does send an e-mail to few employees. The proc was written way before I started my work within the company, I already suggested to go trough code, and rewrite some sql - got rejection, so not sure how else to handle the issues.
Thank you.|||...I already suggested to go trough code, and rewrite some sql - got rejectionBlindman's principle of employement: Never work for people who aren't as smart as you.|||Does that make you unemployed Blinddude? :p|||Does that make you unemployed Blinddude? :p
More like unemployable.;)
hmscott|||that's how you guys have so much time to post.|||your boss doesn't have to be as smart as you.
what's important is that he/she does what you tell them to do. :)
I have scheduled job that are scheduled to run every 2 hours.
Its exec stored procedures. Normal execution time is up to 10 min.
But recently job not running successfully, its just executes forever. So I had to kill that job and I run it manually.
Please help,
I have no idea why it stops executing on its own by the schedule.
Thank you,did you use sp_who2 to see if it is blocked?
did you use dbcc_inputbuffer or sql_handle to see if the code executing changed?
did you create an output file in the job scheduler to capture output from the job steps?
did you change the procs to write to the output file as each starts, runs, and ends?
did you logically think "what can i do to troubleshoot this issue?"
did you google for similar situations?
did you look at the "sticky" at the top of the forum to see what you might need to add to your post to help us help you?|||Thank you for all of the suggestions you have for me.
I will try them one by one.|||How about trying one of the easiest things, stop and start the sql agent. Sometimes the scheduler gets wacked out and a simple stop and start will fix it.|||Does the code contains loops or cursors?|||Does the code contains loops or cursors?
while (1=1)
begin
print 'probably'
end|||The procedure does contain cursors and it runs Ok via SQL Query Analyzer, but once I add it up to SQL Server Agent Job it takes forever...
I do have an output file to capture output from the job steps, but since the job never been completed, and I had to kill it, there are no completion info.
If I will stop and start the sql agent before execution of this job, how the other scheduled processes be affected by that?
Thank you|||Whatever other issues may be occurring, step #1 is to drop the cursors and use set-based operations.|||Unless the jobs sends separate e-mails to employees, for example...|||The procedure does send an e-mail to few employees. The proc was written way before I started my work within the company, I already suggested to go trough code, and rewrite some sql - got rejection, so not sure how else to handle the issues.
Thank you.|||...I already suggested to go trough code, and rewrite some sql - got rejectionBlindman's principle of employement: Never work for people who aren't as smart as you.|||Does that make you unemployed Blinddude? :p|||Does that make you unemployed Blinddude? :p
More like unemployable.;)
hmscott|||that's how you guys have so much time to post.|||your boss doesn't have to be as smart as you.
what's important is that he/she does what you tell them to do. :)
Scheduled job finish time
I would like to find out how long the last execution of a scheduled
task takes to run. Each job i'm looking at has only 1 task. I'm not
crazy about the idea of creating a fake job step to be able to see when
that step starts to know when the "real" job step ended. Is there a
good way to find out the run duration for a job?
KalvinNot sure I follow you. If you right click on the job and choose History you
can see the time the job took. If you check the box for the details it will
expand and show each step as well. If you only have one step (which every
job needs) it is pretty obvious either way.
Andrew J. Kelly SQL MVP
"Kalvin" <ktuel@.streck.com> wrote in message
news:1121874591.381433.81960@.g44g2000cwa.googlegroups.com...
>I would like to find out how long the last execution of a scheduled
> task takes to run. Each job i'm looking at has only 1 task. I'm not
> crazy about the idea of creating a fake job step to be able to see when
> that step starts to know when the "real" job step ended. Is there a
> good way to find out the run duration for a job?
> Kalvin
>|||Would the following system SP give you what you need:
sp_help_jobhistory [ [ @.job_id = ] job_id ]
[ , [ @.job_name = ] 'job_name' ]
[ , [ @.step_id = ] step_id ]
[ , [ @.sql_message_id = ] sql_message_id ]
[ , [ @.sql_severity = ] sql_severity ]
[ , [ @.start_run_date = ] start_run_date ]
[ , [ @.end_run_date = ] end_run_date ]
[ , [ @.start_run_time = ] start_run_time ]
[ , [ @.end_run_time = ] end_run_time ]
[ , [ @.minimum_run_duration = ] minimum_run_duration ]
[ , [ @.run_status = ] run_status ]
[ , [ @.minimum_retries = ] minimum_retries ]
[ , [ @.oldest_first = ] oldest_first ]
[ , [ @.server = ] 'server' ]
[ , [ @.mode = ] 'mode' ]
"Kalvin" <ktuel@.streck.com> wrote in message
news:1121874591.381433.81960@.g44g2000cwa.googlegroups.com...
>I would like to find out how long the last execution of a scheduled
> task takes to run. Each job i'm looking at has only 1 task. I'm not
> crazy about the idea of creating a fake job step to be able to see when
> that step starts to know when the "real" job step ended. Is there a
> good way to find out the run duration for a job?
> Kalvin
>|||yes, that does it.
Thanks
Kalvin
*** Sent via Developersdex http://www.examnotes.net ***
task takes to run. Each job i'm looking at has only 1 task. I'm not
crazy about the idea of creating a fake job step to be able to see when
that step starts to know when the "real" job step ended. Is there a
good way to find out the run duration for a job?
KalvinNot sure I follow you. If you right click on the job and choose History you
can see the time the job took. If you check the box for the details it will
expand and show each step as well. If you only have one step (which every
job needs) it is pretty obvious either way.
Andrew J. Kelly SQL MVP
"Kalvin" <ktuel@.streck.com> wrote in message
news:1121874591.381433.81960@.g44g2000cwa.googlegroups.com...
>I would like to find out how long the last execution of a scheduled
> task takes to run. Each job i'm looking at has only 1 task. I'm not
> crazy about the idea of creating a fake job step to be able to see when
> that step starts to know when the "real" job step ended. Is there a
> good way to find out the run duration for a job?
> Kalvin
>|||Would the following system SP give you what you need:
sp_help_jobhistory [ [ @.job_id = ] job_id ]
[ , [ @.job_name = ] 'job_name' ]
[ , [ @.step_id = ] step_id ]
[ , [ @.sql_message_id = ] sql_message_id ]
[ , [ @.sql_severity = ] sql_severity ]
[ , [ @.start_run_date = ] start_run_date ]
[ , [ @.end_run_date = ] end_run_date ]
[ , [ @.start_run_time = ] start_run_time ]
[ , [ @.end_run_time = ] end_run_time ]
[ , [ @.minimum_run_duration = ] minimum_run_duration ]
[ , [ @.run_status = ] run_status ]
[ , [ @.minimum_retries = ] minimum_retries ]
[ , [ @.oldest_first = ] oldest_first ]
[ , [ @.server = ] 'server' ]
[ , [ @.mode = ] 'mode' ]
"Kalvin" <ktuel@.streck.com> wrote in message
news:1121874591.381433.81960@.g44g2000cwa.googlegroups.com...
>I would like to find out how long the last execution of a scheduled
> task takes to run. Each job i'm looking at has only 1 task. I'm not
> crazy about the idea of creating a fake job step to be able to see when
> that step starts to know when the "real" job step ended. Is there a
> good way to find out the run duration for a job?
> Kalvin
>|||yes, that does it.
Thanks
Kalvin
*** Sent via Developersdex http://www.examnotes.net ***
Friday, March 9, 2012
schedule the task
I want to schedule the task using contro panel schedule task item.
I want to run two package in sequence. If the execution of one gets over then other should start.
I have configured the execution detail in BAT file.
I know how to schedule the task. But can anyone please suggest me how to schedule the task in sqeuence i.e. execution of BAT file in sequenece (one after other).
I suggest that specifing job from sql server agent is the best way to execute sequeneced package|||leo1 wrote:
I want to run two package in sequence. If the execution of one gets over then other should start.
Try the master package scenario mentioned here -
Run multiple SSIS packages in order - MSDN Forums
(http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=748282&SiteID=1)
thanks for the reply.
But My packages are not dependent. and I want to use the windows schedule task.
I want to run it using the BAT file, PLease suggest me how to schedule it using windows scheudle task one after other
|||"one after other" means dependent, in my understanding of English. If you are worried about packages failing, but still want to execute the subsequent package, then you can still use a master package with precedence constraints, as they can be evaluated for success, failure or completion.
If you want to use Windows Scheduler and a batch file, then do so. Are you asking how to call a package from a batch file? If so lookup DTEXEC in Books Online. Just add multiple calls to DTEXEC in the batch file.
Saturday, February 25, 2012
schedule dts at a remote server
Hi
Can somenone help me build a DTS in SQL Server 2000 that allows to schedule
the execution of a executable file in a remote server without sql server?...
[]
RickyRicky,
try to read up on xp_cmdshell in BOL.
--
Venkat
sql server admirer
"Ricky" wrote:
> Hi
> Can somenone help me build a DTS in SQL Server 2000 that allows to schedul
e
> the execution of a executable file in a remote server without sql server?.
.
> []
> Ricky
>
>
>|||Ricky,
try to read up on xp_cmdshell in BOL.
--
Venkat
sql server admirer
"Ricky" wrote:
> Hi
> Can somenone help me build a DTS in SQL Server 2000 that allows to schedul
e
> the execution of a executable file in a remote server without sql server?.
.
> []
> Ricky
>
>
>|||I didn't understand what "xp_cmdshell in BOL" is. Can you explain better.
Sorry but i'm a newbie on this matter.
Thanks
Ricky
"Venkat" <Venkat@.discussions.microsoft.com> wrote in message
news:39EFAD0A-689B-441E-A444-9CC7FCA660D8@.microsoft.com...[vbcol=seagreen]
> Ricky,
> try to read up on xp_cmdshell in BOL.
> --
> Venkat
> sql server admirer
>
> "Ricky" wrote:
>|||I didn't understand what "xp_cmdshell in BOL" is. Can you explain better.
Sorry but i'm a newbie on this matter.
Thanks
Ricky
"Venkat" <Venkat@.discussions.microsoft.com> wrote in message
news:39EFAD0A-689B-441E-A444-9CC7FCA660D8@.microsoft.com...[vbcol=seagreen]
> Ricky,
> try to read up on xp_cmdshell in BOL.
> --
> Venkat
> sql server admirer
>
> "Ricky" wrote:
>
Can somenone help me build a DTS in SQL Server 2000 that allows to schedule
the execution of a executable file in a remote server without sql server?...
[]
RickyRicky,
try to read up on xp_cmdshell in BOL.
--
Venkat
sql server admirer
"Ricky" wrote:
> Hi
> Can somenone help me build a DTS in SQL Server 2000 that allows to schedul
e
> the execution of a executable file in a remote server without sql server?.
.
> []
> Ricky
>
>
>|||Ricky,
try to read up on xp_cmdshell in BOL.
--
Venkat
sql server admirer
"Ricky" wrote:
> Hi
> Can somenone help me build a DTS in SQL Server 2000 that allows to schedul
e
> the execution of a executable file in a remote server without sql server?.
.
> []
> Ricky
>
>
>|||I didn't understand what "xp_cmdshell in BOL" is. Can you explain better.
Sorry but i'm a newbie on this matter.
Thanks
Ricky
"Venkat" <Venkat@.discussions.microsoft.com> wrote in message
news:39EFAD0A-689B-441E-A444-9CC7FCA660D8@.microsoft.com...[vbcol=seagreen]
> Ricky,
> try to read up on xp_cmdshell in BOL.
> --
> Venkat
> sql server admirer
>
> "Ricky" wrote:
>|||I didn't understand what "xp_cmdshell in BOL" is. Can you explain better.
Sorry but i'm a newbie on this matter.
Thanks
Ricky
"Venkat" <Venkat@.discussions.microsoft.com> wrote in message
news:39EFAD0A-689B-441E-A444-9CC7FCA660D8@.microsoft.com...[vbcol=seagreen]
> Ricky,
> try to read up on xp_cmdshell in BOL.
> --
> Venkat
> sql server admirer
>
> "Ricky" wrote:
>
schedule dts at a remote server
Hi
Can somenone help me build a DTS in SQL Server 2000 that allows to schedule
the execution of a executable file in a remote server without sql server?...
[]
RickyCan you access shared folders on the remote server? If so you could use
xp_cmdshell to run the command - mapping a Network Drive if necessary. You
will need to set appropriate permissions on the shared folder.
Alternatively if you are using the DTS package to unconditionally run the
executable then instead you could just schedule the executable on the remote
server using Windows Scheduled Tasks.
Chris
"Ricky" wrote:
> Hi
> Can somenone help me build a DTS in SQL Server 2000 that allows to schedul
e
> the execution of a executable file in a remote server without sql server?.
.
> []
> Ricky
>
>
>|||Thanks for the tip. But i must go with the first option once i've tried the
second option you advice but the excutable i want to run in the remote
server doesn't do an audit to the software and hardware of the remote
server.
The executable file is audit32.exe from www.itsolutions.intuit.com
Can you design for me the dts and send it to my email?.. Or give me the
right/direct way of doing that in DTS of SQL Server 2000.
Thanks
[]
Ricky
"Chris Howarth" <ChrisHowarth@.discussions.microsoft.com> wrote in message
news:193887B6-D869-45D2-A6DC-362A62009FBA@.microsoft.com...
> Can you access shared folders on the remote server? If so you could use
> xp_cmdshell to run the command - mapping a Network Drive if necessary. You
> will need to set appropriate permissions on the shared folder.
> Alternatively if you are using the DTS package to unconditionally run the
> executable then instead you could just schedule the executable on the
> remote
> server using Windows Scheduled Tasks.
> Chris
>
> "Ricky" wrote:
>|||Ricky wrote:
> Thanks for the tip. But i must go with the first option once i've tried th
e
> second option you advice but the excutable i want to run in the remote
> server doesn't do an audit to the software and hardware of the remote
> server.
> The executable file is audit32.exe from www.itsolutions.intuit.com
> Can you design for me the dts and send it to my email?.. Or give me the
> right/direct way of doing that in DTS of SQL Server 2000.
>
So you're trying to perform a Trackit audit on a remote machine from
within SQL Server? This isn't going to work. That executable file must
be run ON THE MACHINE that you want to audit. Running it from within
SQL, via xp_cmdshell, DTS, SQL Agent, whatever, is going to execute it
on the SQL Server machine, not the remote machine. You're either going
to have to schedule it on the remote machine itself, or find some way to
open a remote command shell to the remote machine.|||"Tracy McKibben" <tracy@.realsqlguy.com> wrote in message
news:%23eePm2flGHA.3528@.TK2MSFTNGP02.phx.gbl...
> Ricky wrote:
> So you're trying to perform a Trackit audit on a remote machine from
> within SQL Server? This isn't going to work. That executable file must
> be run ON THE MACHINE that you want to audit. Running it from within SQL,
> via xp_cmdshell, DTS, SQL Agent, whatever, is going to execute it on the
> SQL Server machine, not the remote machine. You're either going to have
> to schedule it on the remote machine itself, or find some way to open a
> remote command shell to the remote machine.
You're right but to run the Trackit audit in the remote server i only have
to
let the file in that specific remote server and share the directory where is
it.
The final purpose is to make a DTS with schedule and force the Trackit audit
run at x time. So i need help for this design. Can you help me?...
Thanks
Ricky|||Ricky wrote:
> "Tracy McKibben" <tracy@.realsqlguy.com> wrote in message
> news:%23eePm2flGHA.3528@.TK2MSFTNGP02.phx.gbl...
>
> You're right but to run the Trackit audit in the remote server i only have
> to
> let the file in that specific remote server and share the directory where
is
> it.
> The final purpose is to make a DTS with schedule and force the Trackit aud
it
> run at x time. So i need help for this design. Can you help me?...
> Thanks
> Ricky
>
Running the executable from a job ON YOUR SQL SERVER is NOT going to
execute it on the remote server. To illustrate, go to your SQL Server
machine, open Explorer, navigate to the executable via the UNC path to
your remote share. If you double-click on the executable, it's going to
run within the context of your SQL Server machine.
You need to run the audit within the context of the remote machine,
meaning it needs to be scheduled ON THE REMOTE SERVER.|||"Tracy McKibben" <tracy@.realsqlguy.com> wrote in message
news:elzOtfmlGHA.3588@.TK2MSFTNGP02.phx.gbl...
> Ricky wrote:
> Running the executable from a job ON YOUR SQL SERVER is NOT going to
> execute it on the remote server. To illustrate, go to your SQL Server
> machine, open Explorer, navigate to the executable via the UNC path to
> your remote share. If you double-click on the executable, it's going to
> run within the context of your SQL Server machine.
> You need to run the audit within the context of the remote machine,
> meaning it needs to be scheduled ON THE REMOTE SERVER.
>
Yes i know that. The audit must be schedule on the Remote Server.
But couldn't i do that by creating a DTS Schedule that will run in a shared
directory where is the audit32.exe?
Thanks
Ricky|||Ricky wrote:
> Yes i know that. The audit must be schedule on the Remote Server.
> But couldn't i do that by creating a DTS Schedule that will run in a share
d
> directory where is the audit32.exe?
> Thanks
> Ricky
>
Open Windows Explorer on your SQL Server machine. Navigate to the
remote share that contains the audit32.exe file, double-click the exe
file. Where does the program run? It runs on your SQL Server machine.
If you schedule the job ON THE SQL SERVER MACHINE, SQL is going to do
exactly what you just did - it's going to pull the exe from the remote
share and run it, ON THE SQL SERVER MACHINE. I really truly don't know
a better way to explain execution context to you, perhaps you should
consult with one of your local IT guys?|||"Tracy McKibben" <tracy@.realsqlguy.com> wrote in message
news:uP9vpFMmGHA.856@.TK2MSFTNGP03.phx.gbl...
> Ricky wrote:
> Open Windows Explorer on your SQL Server machine. Navigate to the remote
> share that contains the audit32.exe file, double-click the exe file.
> Where does the program run? It runs on your SQL Server machine. If you
> schedule the job ON THE SQL SERVER MACHINE, SQL is going to do exactly
> what you just did - it's going to pull the exe from the remote share and
> run it, ON THE SQL SERVER MACHINE. I really truly don't know a better way
> to explain execution context to you, perhaps you should consult with one
> of your local IT guys?
Ok. I've already understand what you mean. So what do you advice then? Once
i've already try windows schedule and didn't work well.
Thanks
Ricky|||Ricky wrote:
> Ok. I've already understand what you mean. So what do you advice then? Onc
e
> i've already try windows schedule and didn't work well.
> Thanks
> Ricky
>
Recent versions of TrackIT offer the ability to do scheduled audits.
Consult your Administrator's Guide for details on how to set one up.
Can somenone help me build a DTS in SQL Server 2000 that allows to schedule
the execution of a executable file in a remote server without sql server?...
[]
RickyCan you access shared folders on the remote server? If so you could use
xp_cmdshell to run the command - mapping a Network Drive if necessary. You
will need to set appropriate permissions on the shared folder.
Alternatively if you are using the DTS package to unconditionally run the
executable then instead you could just schedule the executable on the remote
server using Windows Scheduled Tasks.
Chris
"Ricky" wrote:
> Hi
> Can somenone help me build a DTS in SQL Server 2000 that allows to schedul
e
> the execution of a executable file in a remote server without sql server?.
.
> []
> Ricky
>
>
>|||Thanks for the tip. But i must go with the first option once i've tried the
second option you advice but the excutable i want to run in the remote
server doesn't do an audit to the software and hardware of the remote
server.
The executable file is audit32.exe from www.itsolutions.intuit.com
Can you design for me the dts and send it to my email?.. Or give me the
right/direct way of doing that in DTS of SQL Server 2000.
Thanks
[]
Ricky
"Chris Howarth" <ChrisHowarth@.discussions.microsoft.com> wrote in message
news:193887B6-D869-45D2-A6DC-362A62009FBA@.microsoft.com...
> Can you access shared folders on the remote server? If so you could use
> xp_cmdshell to run the command - mapping a Network Drive if necessary. You
> will need to set appropriate permissions on the shared folder.
> Alternatively if you are using the DTS package to unconditionally run the
> executable then instead you could just schedule the executable on the
> remote
> server using Windows Scheduled Tasks.
> Chris
>
> "Ricky" wrote:
>|||Ricky wrote:
> Thanks for the tip. But i must go with the first option once i've tried th
e
> second option you advice but the excutable i want to run in the remote
> server doesn't do an audit to the software and hardware of the remote
> server.
> The executable file is audit32.exe from www.itsolutions.intuit.com
> Can you design for me the dts and send it to my email?.. Or give me the
> right/direct way of doing that in DTS of SQL Server 2000.
>
So you're trying to perform a Trackit audit on a remote machine from
within SQL Server? This isn't going to work. That executable file must
be run ON THE MACHINE that you want to audit. Running it from within
SQL, via xp_cmdshell, DTS, SQL Agent, whatever, is going to execute it
on the SQL Server machine, not the remote machine. You're either going
to have to schedule it on the remote machine itself, or find some way to
open a remote command shell to the remote machine.|||"Tracy McKibben" <tracy@.realsqlguy.com> wrote in message
news:%23eePm2flGHA.3528@.TK2MSFTNGP02.phx.gbl...
> Ricky wrote:
> So you're trying to perform a Trackit audit on a remote machine from
> within SQL Server? This isn't going to work. That executable file must
> be run ON THE MACHINE that you want to audit. Running it from within SQL,
> via xp_cmdshell, DTS, SQL Agent, whatever, is going to execute it on the
> SQL Server machine, not the remote machine. You're either going to have
> to schedule it on the remote machine itself, or find some way to open a
> remote command shell to the remote machine.
You're right but to run the Trackit audit in the remote server i only have
to
let the file in that specific remote server and share the directory where is
it.
The final purpose is to make a DTS with schedule and force the Trackit audit
run at x time. So i need help for this design. Can you help me?...
Thanks
Ricky|||Ricky wrote:
> "Tracy McKibben" <tracy@.realsqlguy.com> wrote in message
> news:%23eePm2flGHA.3528@.TK2MSFTNGP02.phx.gbl...
>
> You're right but to run the Trackit audit in the remote server i only have
> to
> let the file in that specific remote server and share the directory where
is
> it.
> The final purpose is to make a DTS with schedule and force the Trackit aud
it
> run at x time. So i need help for this design. Can you help me?...
> Thanks
> Ricky
>
Running the executable from a job ON YOUR SQL SERVER is NOT going to
execute it on the remote server. To illustrate, go to your SQL Server
machine, open Explorer, navigate to the executable via the UNC path to
your remote share. If you double-click on the executable, it's going to
run within the context of your SQL Server machine.
You need to run the audit within the context of the remote machine,
meaning it needs to be scheduled ON THE REMOTE SERVER.|||"Tracy McKibben" <tracy@.realsqlguy.com> wrote in message
news:elzOtfmlGHA.3588@.TK2MSFTNGP02.phx.gbl...
> Ricky wrote:
> Running the executable from a job ON YOUR SQL SERVER is NOT going to
> execute it on the remote server. To illustrate, go to your SQL Server
> machine, open Explorer, navigate to the executable via the UNC path to
> your remote share. If you double-click on the executable, it's going to
> run within the context of your SQL Server machine.
> You need to run the audit within the context of the remote machine,
> meaning it needs to be scheduled ON THE REMOTE SERVER.
>
Yes i know that. The audit must be schedule on the Remote Server.
But couldn't i do that by creating a DTS Schedule that will run in a shared
directory where is the audit32.exe?
Thanks
Ricky|||Ricky wrote:
> Yes i know that. The audit must be schedule on the Remote Server.
> But couldn't i do that by creating a DTS Schedule that will run in a share
d
> directory where is the audit32.exe?
> Thanks
> Ricky
>
Open Windows Explorer on your SQL Server machine. Navigate to the
remote share that contains the audit32.exe file, double-click the exe
file. Where does the program run? It runs on your SQL Server machine.
If you schedule the job ON THE SQL SERVER MACHINE, SQL is going to do
exactly what you just did - it's going to pull the exe from the remote
share and run it, ON THE SQL SERVER MACHINE. I really truly don't know
a better way to explain execution context to you, perhaps you should
consult with one of your local IT guys?|||"Tracy McKibben" <tracy@.realsqlguy.com> wrote in message
news:uP9vpFMmGHA.856@.TK2MSFTNGP03.phx.gbl...
> Ricky wrote:
> Open Windows Explorer on your SQL Server machine. Navigate to the remote
> share that contains the audit32.exe file, double-click the exe file.
> Where does the program run? It runs on your SQL Server machine. If you
> schedule the job ON THE SQL SERVER MACHINE, SQL is going to do exactly
> what you just did - it's going to pull the exe from the remote share and
> run it, ON THE SQL SERVER MACHINE. I really truly don't know a better way
> to explain execution context to you, perhaps you should consult with one
> of your local IT guys?
Ok. I've already understand what you mean. So what do you advice then? Once
i've already try windows schedule and didn't work well.
Thanks
Ricky|||Ricky wrote:
> Ok. I've already understand what you mean. So what do you advice then? Onc
e
> i've already try windows schedule and didn't work well.
> Thanks
> Ricky
>
Recent versions of TrackIT offer the ability to do scheduled audits.
Consult your Administrator's Guide for details on how to set one up.
schedule dts at a remote server
Hi
Can somenone help me build a DTS in SQL Server 2000 that allows to schedule
the execution of a executable file in a remote server without sql server?...
[]
RickyRicky,
try to read up on xp_cmdshell in BOL.
--
Venkat
sql server admirer
"Ricky" wrote:
> Hi
> Can somenone help me build a DTS in SQL Server 2000 that allows to schedule
> the execution of a executable file in a remote server without sql server?...
> []
> Ricky
>
>
>|||I didn't understand what "xp_cmdshell in BOL" is. Can you explain better.
Sorry but i'm a newbie on this matter.
Thanks
Ricky
"Venkat" <Venkat@.discussions.microsoft.com> wrote in message
news:39EFAD0A-689B-441E-A444-9CC7FCA660D8@.microsoft.com...
> Ricky,
> try to read up on xp_cmdshell in BOL.
> --
> Venkat
> sql server admirer
>
> "Ricky" wrote:
>> Hi
>> Can somenone help me build a DTS in SQL Server 2000 that allows to
>> schedule
>> the execution of a executable file in a remote server without sql
>> server?...
>> []
>> Ricky
>>
>>
>>
Can somenone help me build a DTS in SQL Server 2000 that allows to schedule
the execution of a executable file in a remote server without sql server?...
[]
RickyRicky,
try to read up on xp_cmdshell in BOL.
--
Venkat
sql server admirer
"Ricky" wrote:
> Hi
> Can somenone help me build a DTS in SQL Server 2000 that allows to schedule
> the execution of a executable file in a remote server without sql server?...
> []
> Ricky
>
>
>|||I didn't understand what "xp_cmdshell in BOL" is. Can you explain better.
Sorry but i'm a newbie on this matter.
Thanks
Ricky
"Venkat" <Venkat@.discussions.microsoft.com> wrote in message
news:39EFAD0A-689B-441E-A444-9CC7FCA660D8@.microsoft.com...
> Ricky,
> try to read up on xp_cmdshell in BOL.
> --
> Venkat
> sql server admirer
>
> "Ricky" wrote:
>> Hi
>> Can somenone help me build a DTS in SQL Server 2000 that allows to
>> schedule
>> the execution of a executable file in a remote server without sql
>> server?...
>> []
>> Ricky
>>
>>
>>
Subscribe to:
Posts (Atom)