Skip to Content
author's profile photo Former Member
Former Member

Schedule script job

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Sep 21, 2011 at 03:35 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.