Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 448
  • Last Modified:

Report execution based on event flag

1.The sql report stored procedure checks for the event flag. If the event flag is there,the report executes. If the event flag is not there,it keep on checking for every 30 minutes and once it find
the event flag, the report will execute.
Is there any way to do this? Please let me know how to do this.
2.I want to know more about event based execution of the reports.

Thanks
0
KavyaVS
Asked:
KavyaVS
1 Solution
 
EvilPostItCommented:
You should be able to do this by editing the SQL Server agent job which is created when first deployed this report. If you add a step into the job before the actual report generation that check for you condition via t-sql or cmd this should work.
0
 
KavyaVSAuthor Commented:
Thanks
0

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Tackle projects and never again get stuck behind a technical roadblock.
Join Now