Results 1 to 4 of 4

Thread: Jobs in MSSQL 2000

  1. Apr 26th, 2007, 05:07 AM #1
    erickwidya
    erickwidya is offline

    Thread Starter
    Fanatic Member
    Join Date
    Sep 2004
    Location
    Jakarta, Indonesia
    Posts
    818

    Jobs in MSSQL 2000

    is executing jobs in MSSQL create a log file? i mean like information that what records that being execute and so on..

    thanks,
    erick

    1st NF - a table should not contain repeating groups.
    2nd NF - any fields that do not depend fully on the primary key should be moved to another table.
    3rd NF - there should be no dependency between non key fields in same table.
    - E. Petroutsos -

    eRiCk

    A collection of "Laku-abis" Ebook, Permanent Residence

    Access Reserved Words, a Classic Form Bug, Access Limitation, Know run Process and the Lock they hold in, Logging User Activity in MSSQL,
    Kill Database Processes
    Reply With Quote Reply With Quote
  2. Apr 27th, 2007, 06:38 AM #2
    The_Duck
    The_Duck is offline
    Hyperactive Member The_Duck's Avatar
    Join Date
    May 2005
    Location
    Leamington, UK
    Posts
    351

    Re: Jobs in MSSQL 2000

    Using Enterprise Manager you can view your jobs. There is a notifications tab that allows you to setup how you recieve job status messages (sucess/fail).
    Reply With Quote Reply With Quote
  3. Apr 27th, 2007, 07:27 AM #3
    szlamany
    szlamany is offline
    MS SQL Powerposter szlamany's Avatar
    Join Date
    Mar 2004
    Location
    Connecticut
    Posts
    18,263

    Re: Jobs in MSSQL 2000

    Those logs are terribily inadequate.

    What kind of steps are you executing in your jobs?

    *** Read the sticky in the DB forum about how to get your question answered quickly!! ***

    Please remember to rate posts! Rate any post you find helpful - even in old threads! Use the link to the left - "Rate this Post".

    Some Informative Links:     [ SQL Rules to Live By ] [ Reserved SQL keywords ] [ When to use INDEX HINTS! ] [ Passing Multi-item Parameters to STORED PROCEDURES ]
    [ Solution to non-domain Windows Authentication ] [ Crazy things we do to shrink log files ] [ SQL 2005 Features ] [ Loading Pictures from DB ]

    MS MVP 2006, 2007, 2008
    Reply With Quote Reply With Quote
  4. Apr 29th, 2007, 09:55 PM #4
    erickwidya
    erickwidya is offline

    Thread Starter
    Fanatic Member
    Join Date
    Sep 2004
    Location
    Jakarta, Indonesia
    Posts
    818

    Re: Jobs in MSSQL 2000

    thx the_duck, sz

    What kind of steps are you executing in your jobs? -> not sure..this for migrate from one database to another, i'm just thinking using SQL Jobs to do that rather than making a new program..but it will need to see the log for what record that sucessfully insert to another db..

    do i make any sense?

    PS: sorry for late reply

    thx,
    erick
    Last edited by erickwidya; Apr 29th, 2007 at 09:59 PM.

    1st NF - a table should not contain repeating groups.
    2nd NF - any fields that do not depend fully on the primary key should be moved to another table.
    3rd NF - there should be no dependency between non key fields in same table.
    - E. Petroutsos -

    eRiCk

    A collection of "Laku-abis" Ebook, Permanent Residence

    Access Reserved Words, a Classic Form Bug, Access Limitation, Know run Process and the Lock they hold in, Logging User Activity in MSSQL,
    Kill Database Processes
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width