Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Schedule a data refresh

Hi, i would like to schedule a refresh of the data but through another scheduling software. I can see you can schedule a refresh but can't see an option to run via dos powershell command which will b...
schedul
Schedule Refresh
Scheduling
andris's avatar
andris
Resolver I
7 years ago

HI.

 

Data refresh is actually done by SQL Server agent job - when you create refresh task in Report Manager, new SQL Server job is created. So, to trigger a refresh, you can start this job via PowerShell, for example.

 

Regards

Andris

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    OK thanks not totally ideal I think.

    Do you know if there any errors coming back from the SQL Agent will it be reported back ok to the calling process. Also when the scheduled proceess runs it may have to wait for the Agent to finish executing. Do you know if that works ok.

    I was hoping that i can call an executable to run the job, calling the SQL Agent may just do things in the background which is not my requirement? Thank you.