on 08-19-2011 6:49 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
24 | |
11 | |
9 | |
7 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.