dbTalk Databases Forums  

Edit DTSRunUI Scheduled Jobs

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Edit DTSRunUI Scheduled Jobs in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
David Grant
 
Posts: n/a

Default Edit DTSRunUI Scheduled Jobs - 03-21-2005 , 04:59 AM






Hi to Everybody,

I've read about DTSRunUI for executing DTS at night. After some
testing I'm sure it does what I expected for.

I'd like to know the way I can edit/delete Scheduled Jobs once they
have been created by DTSRunUI. I've read about the info of these jobs
stored in the msdb database but don't know whether editing these
tables will be enough or there is a graphical tool to reach my goal.


Greetings,
David Grant

Reply With Quote
  #2  
Old   
Allan Mitchell
 
Posts: n/a

Default Re: Edit DTSRunUI Scheduled Jobs - 03-21-2005 , 01:23 PM






Before we go to the tables have a look in EM,

Management | SQL Server Agent | jobs


Allan


"David Grant" <icebold54 (AT) hotmail (DOT) com> wrote


Quote:
Hi to Everybody,

I've read about DTSRunUI for executing DTS at night. After some
testing I'm sure it does what I expected for.

I'd like to know the way I can edit/delete Scheduled Jobs once they
have been created by DTSRunUI. I've read about the info of these jobs
stored in the msdb database but don't know whether editing these
tables will be enough or there is a graphical tool to reach my goal.


Greetings,
David Grant


Reply With Quote
  #3  
Old   
David Grant
 
Posts: n/a

Default Re: Edit DTSRunUI Scheduled Jobs - 03-22-2005 , 01:48 AM



The jobs can be found there (I don't know yet the reason
why I didn't see anything there when I checked the whole EM
tree structure)

Thank You Very Much, Allan.


Greetings,
David Grant
Quote:
-----Original Message-----
Before we go to the tables have a look in EM,

Management | SQL Server Agent | jobs


Allan


"David Grant" <icebold54 (AT) hotmail (DOT) com> wrote in message
news:icebold54 (AT) hotmail (DOT) com:

Hi to Everybody,

I've read about DTSRunUI for executing DTS at night.
After some
testing I'm sure it does what I expected for.

I'd like to know the way I can edit/delete Scheduled
Jobs once they
have been created by DTSRunUI. I've read about the info
of these jobs
stored in the msdb database but don't know whether
editing these
tables will be enough or there is a graphical tool to
reach my goal.


Greetings,
David Grant

.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.