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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Bharat GuruAuthor Commented:
how to find the SQL job from SSRS subscription name?
0
Protecting & Securing Your Critical Data

Considering 93 percent of companies file for bankruptcy within 12 months of a disaster that blocked access to their data for 10 days or more, planning for the worst is just smart business. Learn how Acronis Backup integrates security at every stage

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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SSRS

From novice to tech pro — start learning today.