68349/how-to-schedule-a-job-for-sql-query-to-run-daily
Hii,
To schedule a job for sql query to run daily follow the steps:
Expand the SQL Server Agent node and right click the Jobs node in SQL Server Agent and select 'New Job'
In the 'New Job' window enter the name of the job and a description on the 'General' tab.
Select 'Steps' on the left hand side of the window and click 'New' at the bottom.
In the 'Steps' window enter a step name and select the database you want the query to run against.
Paste in the T-SQL command you want to run into the Command window and click 'OK'.
Click on the 'Schedule' menu on the left of the New Job window and enter the schedule information (e.g. daily and a time).
Click 'OK' - and that should be it.
Hope this works!!
Thank You!!
down voteaccepted Expand the SQL Server Agent node ...READ MORE
On Excel tables, how to construct and ...READ MORE
Use the INFORMATION_SCHEMA.TABLES view to get the ...READ MORE
I am aware that the Group Concat ...READ MORE
Hello, Here is the command you are looking ...READ MORE
Hii I was having the same problem and ...READ MORE
Hello @kartik, I did this to set my ...READ MORE
Hello @kartik, I got the same issue when ...READ MORE
Hello, Depending on the DB, you can do ...READ MORE
Hello @kartik, You have two options: FLUSHDB - clears currently ...READ MORE
OR
At least 1 upper-case and 1 lower-case letter
Minimum 8 characters and Maximum 50 characters
Already have an account? Sign in.