https://www.oracle.com/technetwork/topics/parameterized-url-red-paper-128781.pdf
For Batch number:-
https://jdepd.xxxxx.com/jde/HostedE1Servlet?OID=P0011_W0011A&FormDSTmpl=|2|&FormDSData=|123456|
This is my technical area for troubleshooting and learning new programming skills and much more. Here, you will find answers on a wide range of technologies such as AI, Machine Learning, OpenAI, Databricks, ASP.NET, C#, Python, Microsoft Access, MySQL, Amazon Web Services, SQL Server, PL/SQL, JD Edwards, SAS, Salesforce, APIs, MVC, and many others. Please feel free to visit and join the discussion!
https://www.oracle.com/technetwork/topics/parameterized-url-red-paper-128781.pdf
For Batch number:-
https://jdepd.xxxxx.com/jde/HostedE1Servlet?OID=P0011_W0011A&FormDSTmpl=|2|&FormDSData=|123456|
--print 'Rajeev.Kumar@MolinaHealthCare.Com' + ';'+ @sndemail + ','
set @subj = 'Auto: ' + @processname + ' - Budget Routine Done'
SET @tableHTML=
N'<html><body>'+ 'Hi, ' + '<br>' +
N'<br>'+
N'' + @processname + ' completed successfully.<br></H4>' +
N'<H3>Thank You<br>'+
N'<br></H3></body></html>'
exec msdb.dbo.sp_send_cdosysmail
@From = N'Rajeev.Kumar@xxxxxx.Com',
@To = @sndemail,
@cc=N'Rajeev.Kumar@xxxx.Com',
@ReplyTo = N'Rajeev.Kumar@xxxx.Com',
@Subject = @subj,
@Body = @tableHTML,
@BodyType ='HTMLBODY'
Submit SQL server job from webpage in ASP.NET, C#
void submitjob_corpalloc(string FY)
{
SqlConnection DbConn = new SqlConnection(ConnectionString);
SqlCommand ExecJob = new SqlCommand();
ExecJob.CommandType = System.Data.CommandType.StoredProcedure;
ExecJob.CommandText = "msdb.dbo.sp_start_job";
if (FY == "2020")
{
//ExecJob.Parameters.AddWithValue("@job_name", "RunbudgetRoutineMultiYr"); //SP_tblRunEtl_Job
//ExecJob.Parameters.AddWithValue("@job_name", "RunbudgetRoutineMultiYr"); //sp_etljob_2020
ExecJob.Parameters.AddWithValue("@job_name", "BudgetRoutine_2020");
ExecJob.Connection = DbConn; //assign the connection to the command.
using (DbConn)
{
DbConn.Open();
using (ExecJob)
{
ExecJob.ExecuteNonQuery();
}
}
}
{
xtype:
'checkboxfield',
boxLabel: 'All Municipal',
name: 'AllMunicipal',
margin: '0 0 0 0',
listeners: {
change: function (checkbox, newVal, oldVal) {
if (newVal == '1' && oldVal == '0') {
var allCheckBoxes = checkbox.up('checkboxgroup').items.items;
for (var i = 0; i < allCheckBoxes.length; i++)
{
allCheckBoxes[i].setValue('1');
}
}
}
}
}
https://forum.sencha.com/forum/showthread.php?137463-Checkbox-Click-Event
DECLARE @tDate DATETIMESET @tDate = GETDATE()SELECT @tDate AS 'Input Date', DATEADD(q, DATEDIFF(q, 0, @tDate ), 0) AS 'frmDate', DATEADD(d, -1, DATEADD(q, DATEDIFF(q, 0, @tDate ) + 1, 0)) AS 'toDate'