How to install SQL Server Job on Host server using Plesk

Question

I test sqljob in local host for using sqljob in host what should I doI take backup of my database and upload it in host but I dont know for sqljob what should I do Thanks alot

nedash · Accepted Answer

okI did  itsimply write below code on note pad and save it with vbs Extention  Call ScheduleSub ScheduleOn Error Resume NextDim objRequestDim URLSet objRequest  CreateObjectldquoMicrosoftXMLHTTPrdquoURL  ldquohttpwwwyourdomaincomtestaspxrdquoobjRequestopen ldquoPOSTrdquo URL  falseobjRequestSendSet objRequest  NothingEnd Suband in aspx page write below code    SqlConnection cn  new SqlConnectionSystemWebConfigurationWebConfigurationManagerConnectionStrings34behtopConnectionString34ConnectionString    protected void PageLoadobject sender EventArgs e            SqlCommand cmd  new SqlCommand34DeleteData34 cn        cmdCommandType  CommandTypeStoredProcedure        cnOpen        cmdExecuteNonQuery        cnClose    after that upload  vbs and aspx file  and  in plesk panle go to schedualTask menu and create new Task and set datedayTime for it to run your vbs fileafter set below changesSwitched

How to install SQL Server Job on Host server using Plesk

Company

Explore

Follow us

Contact Us