cancel
Showing results for 
Search instead for 
Did you mean: 

Schedule script job

Former Member
0 Kudos

Hello Experts,

I want to schedule one job which is daily frequency and start early morning 8.00AM.

Below is the query.

*select org_cd,bill_no,bill_dt,itm_cd,item_name,ean_no,qty,net_value from pos_sales_dtl

where

--bill_dt between '01-July-2011' and '10-July-2011'

Convert(Varchar(30),bill_dt,112) = Convert(Varchar(30),Getdate()-1 ,112)

and void_flag = 'F'

SELECT org_cd,ret_doc_no,ret_doc_dt,itm_cd,itm_name,ret_qty,net_value

FROM POS_SALES_RETURN_DTL

WHERE Convert(Varchar(30),RET_DOC_DT ,112) = Convert(Varchar(30),Getdate()-1 ,112)

and void_flag = 'F'*

and after running this job, this will come into excel sheet and transfer to specific folder.

Can we schedule any kind of job for such activity.

If it is possible then please let me know the procedure.

Regards

Hemant G

Accepted Solutions (1)

Accepted Solutions (1)

rupali_karbhari3
Active Contributor
0 Kudos

Hi Hemanth,

Check Maintenance Plan functionality in SQL server management studio.

This might help you to create plan with list of activity

1. run a query

2. generate a excel sheet output

3. place output to perticuler folder.

Best Regards,

Rupali

Former Member
0 Kudos

Thanks Rupali.

For your response.

I have resolved this issue by the help of SQL administrator.

Regards

Hemant G

Answers (0)