mary jean ligas

mary jean ligas

  • NA
  • 420
  • 197.2k

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)

0
Raja T

Raja T

  • 331
  • 5.4k
  • 110.1k
Feb 2 2016 11:21 PM
Hello Mary, Please refer below links 
 
http://www.excel-sql-server.com/excel-import-to-sql-server-using-distributed-queries.htm
 
http://stackoverflow.com/questions/18506780/using-query-export-sql-server-2008-table-to-excel-sheet?answertab=active#tab-top 
0
mary jean ligas

mary jean ligas

  • 0
  • 420
  • 197.2k
Feb 2 2016 7:44 PM
hi sir chandu the thing is we cannot use SSIS in our server. Not allowed to install on our PC
0
Chandu Kumawat

Chandu Kumawat

  • 0
  • 1.4k
  • 91.6k
Feb 2 2016 5:44 AM
hi... refer this idea
0
Chandu Kumawat

Chandu Kumawat

  • 0
  • 1.4k
  • 91.6k
Feb 2 2016 5:33 AM
k i will try
0
mary jean ligas

mary jean ligas

  • 0
  • 420
  • 197.2k
Feb 2 2016 5:19 AM
hi sir not in windows task scheduler but I need to user Job scheduler on sql server agent..Thanks
0
Chandu Kumawat

Chandu Kumawat

  • 0
  • 1.4k
  • 91.6k
Feb 2 2016 4:34 AM
https://support.office.com/en-us/article/Schedule-an-import-or-export-operation-34b181e4-1564-4428-bf5c-a222e83f2a68