is executing jobs in MSSQL create a log file? i mean like information that what records that being execute and so on..
thanks,
erick
Printable View
is executing jobs in MSSQL create a log file? i mean like information that what records that being execute and so on..
thanks,
erick
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).
Those logs are terribily inadequate.
What kind of steps are you executing in your jobs?
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