Skip to Content
0
Former Member
Aug 19, 2011 at 05:49 AM

Schedule script job

45 Views

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