Run a VBscript using SQL Server.

By -
Today I came across a question in EE of how to run a VBscript using SQL server.
Well, it could be done using the SQL server agent or using SSIS, but the easiest way would be the SQL agent.

Here how:

1-Right click on "SQL Server Agent" and select "New Job"
2-Name the job according to your needs.
3-From the "Steps" , select New.
4-Name it to your needs and select the "Type" as "Operating System CmdExec" as shown in the screenshot.
4-Set the schedule as desired and that's it!!




Comments

  1. AnonymousFebruary 6, 2013 at 4:05 PM

    I wish it were that easy. What if SQL Server Agent doesn't have sufficient privileges to run the vbscript file? I can't get it to run at all.

    ReplyDelete
  2. awaisMay 23, 2020 at 12:36 AM

    Thanks for the tips guys. They were all great. I have been having issues with being fat both mentally and physically. Thanks to you guys i have been showing improvements. Do post more. https://serverbrowse.com/

    ReplyDelete

Post a Comment

Popular posts from this blog

Open SSRS Linked URLS in a new window

By -
Image
Greetings....as I mentioned before sometimes I use my blog posts as a way to remind myself of the stuff that I need frequently and never keep to memory. I needed to add a link in a new SSRS report and the link has to open in a new browser's window. Just Right click on your report field, select "Text Box Properties", select "Action", click on the "FX" sign to write that special expression. ="javascript:void(window.open('" + Fields!URL.Value + "','_blank'))" Assuming that your URL is dynamic and the column name is "URL" in your dataset SSRS Link in  new Browser's Window Hope that helps...
Read more

SSRS Font Weight expressions

By -
Image
Recently I was tasked to edit an old SSRS report, the report has multiple columns and I need to change the font weight to BOLD based on a specific value. It's so simple but annoying that it needs to be done manually to all the columns that you need the expression to check. which was 25 columns in my case! Steps: Right-click on the column and select "text Box Properties" Select "Font" from the left menu Next to BOLD click on the expression menu In the expression screen; write the expression based on your column and the condition. =IIF(Fields!JB.Value > 0, "Bold","Normal") So here I'm setting the Property "FontWeight" of the textbox to be "Bold" when the value is greater than 0, otherwise, you're setting it to "Normal". hope that helps!
Read more