mary jean ligas

mary jean ligas

  • NA
  • 420
  • 191.9k

Create a job scheduler that export the data to excel

Feb 2 2016 4:30 AM

Please help me Master,

I need to create a Job scheduler that will export the data from table to excel file.. please help me on how to design I am first timer in sql server agent job and don't know how to start..

I have a first table that the columns are:
time interval : 2 min
time start    : 8 am
time schedule : 2 pm

(note in this table if time schedule is enable then neglect time interval and time start, then if time interval and time start is enable neglect the time schedule)

the plan is to run job scheduler and the first step is to check the first table time schedule, then if time schedule happen then extract data from table to excel..

please give me a big help as I really appreciate you all masters. Thanks

 


Answers (6)