How to change the timing of SQL SSRS job using TSQL

I have a subscription job schedule to run at 5:00 pm how can I change it to 6:00 pm using the tsql by subscription name?
Bharat GuruAsked:
Who is Participating?
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Just in case you don't know the schedule name, it can be returned by this SELECT where you just need to know the job name:
SELECT s.name
FROM sysjobs j
	INNER JOIN sysjobschedules js ON j.job_id = js.job_id
	INNER JOIN sysschedules s ON js.schedule_id=s.schedule_id
WHERE j.name = 'Job Name Here'

Open in new window

0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Do you know the schedule name for that job?
If so then just run the following command:
EXEC dbo.sp_update_schedule @name = 'Schedule Name Here', @active_start_time ='180000'

Open in new window

0
 
Bharat GuruAuthor Commented:
how to find the SQL job from SSRS subscription name?
0
Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Sorry, guessing is not one of my expertise.
You need to see the jobs in SQL Server Agent or directly from sysjobs (SELECT name FROM sysjobs). The name should be something easy to guess, then.
0
 
Scott PletcherSenior DBACommented:
Change it in the SSRS scheduling area.  SSRS can get very mean if you try to change its jobs on your own; often the job simply quits working and it's very difficult to fix.
0
 
Bharat GuruAuthor Commented:
Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.